Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I'm trying to use the function FirstSortedValue() to find the first value according to three columns. The ID column, the Date column and the the Name column. Could somebody helps me? thanks in advance for your help :). see the dataset .
@Ibobob70 Could you share the desired output?
Since FirstSortedValue takes a single sort_weight parameter, I believe you'd need to turn those three fields into one somehow:
1) In script by loading them in sorted order and adding a row number or autonumber field for sorting later
2) By concatenating them as a string (note - this will result in string based sorting rather than numeric)
3) By converting the Name column into a numeric value and adding the values up, e.g.
(ID * 10000000) + (Date*100) + ord(Name) // Note - this assumes Name is a single letter
Thank you for your help 🙂 i'll try it.