Filtered List inside same Table

Discussion created by Wicktor on Nov 12, 2016
Latest reply on Nov 12, 2016 by taylorsharpe

Hello everyone,

I have TableA with some 150.000 records.

VALUE_1 (stored) contains calculated numbers in a range between -20 up to 20 (step 0,1).

More than one record may have the same value inside VALUE_1.

I need to produce a calculated LIST_1 of unique values stored inside VALUE_1 (without a script).

LIST_1 will be compared with LIST_2 inside TableB where value inside that range are unique.

The final result would be a check if LIST_1 and LIST_2 have same values.

Thank you for any help :-)