- Posts: 3
- Thank you received: 0
Hi there,
This is likely a stupid question, but is it possible to show unique values if there are several lines with identical identifiers? What I mean is: I have a table for which I'm not showing all information, so several lines are shown with the same exact values (because the column with the different values isn't shown). What I'd like to see is that the lines with the same data show only once.
Is there a setting for this?
Thanks in advance!
Regards, Roger
Please Log in or Create an account to join the conversation.
Hi,
there is not a direct setting like this in Tools JX. However you can create a database view with CREATE VIEW and SELECT DISTINCT, and than use this view with Table JX.
toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx
Please Log in or Create an account to join the conversation.