Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to output as:
I want the rows which has maximun FieldNo for respective Table Column.
Thanks
if you want output as a straight table, use max(FieldNo) for your FieldNo, and aggr(firstsortedvalue(Field,-FieldNo),Table) for your Field