How to list out Unique data?
=NL("Rows","TableName")
Example Data:
A
A
B
B
B
C
C
Result:
A
B
C
Date
Votes
7 comments
-
Jet Reports Historic Posts Official comment =NL("Rows","MyTable","MyField") makes the resulting field unique.
-
Jet Reports Historic Posts Thank you! your answer is work!
-
Jet Reports Historic Posts So basically I would just put the field that I want unique values for in the "Field" box?
What about if I am using A key? How can I get only unique values when I have to leave the "field" box open for my key to work?
V/R,
Gustavo -
Jet Reports Historic Posts Hi Gustavo,
If you need a record key than you will have to use multiple Jet functions. You can replicate the unique values for a particular field by specifying that field in the Field parameter of the NL function. Then you could use an NL(First) function with no field specified with a filter on the value from your other function to get the record key. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Or do you mean how to get a combination of fields unique?
Try:
E5 = NL("Rows","Table",{"Field 1","Field 2"})
F5 = NF($E5,"Field 1")
G5 = NF($E5,"Field 2") -
Jet Reports Historic Posts I used Hilton's method and it worked. It took me a bit to figure out how to do it, but once I realized that you were telling me to use the NL(First) function with blank field as the new key, I got it to work.
Thanks! -
László Farkas In case anyone is still facing this question, as I was just now:
First off the correct formula in the original post should have been: =NL("Rows","TableName","FieldName")
To get the desired result with unique values only, here is hat worked for me, added as a filter:
=NL("Rows","TableName","FieldName","IncludeDuplicates=","False")
Please sign in to leave a comment.