Forum Discussion
konradjonsson
7 years agoHelper II
How to create a table and exclude certain row values?
I want to create a new table that include a) all SERIAL NUMBERS (unique) and b) the DATE when the serial number was first invoiced. (this is to later on cross-reference this date with all subsequent...
- 7 years ago
Hey,
I do not fully understand ,,, but nevertheless maybe a simple DISTINCT around the SELECTCOLUMNS from my 1st answer is all you need, to bend the table to your will, like so:
DISTINCT( SELECTCOLUMNS( .... ) )Regards,
Tom
TomMartens
7 years agoSuper User
Hey,
I do not fully understand ,,, but nevertheless maybe a simple DISTINCT around the SELECTCOLUMNS from my 1st answer is all you need, to bend the table to your will, like so:
DISTINCT(
SELECTCOLUMNS(
....
)
)
Regards,
Tom
konradjonsson
7 years agoHelper II
Yes, now it did solve the problem!
Brilliant - thanks a lot!
/Konrad