Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I required the desired rank column in the given excel below.
At the month end date and max of the last month I need numbering in the descending order .
Please look into the excel for better understanding.
Thanks
Perhaps this?
Table:
LOAD Date,
Category,
Product,
Flag
FROM
[Comm1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join
Load *, If(Flag<>0, AutoNumber(RecNo(), Product), '') as Dense_Rank Resident Table Order By Date desc;
Perhaps simply like
Table:
Load * From <Excel>;
Left Join(Table)
Load Date, Category, Flag, If(Flag<>0, RowNo()) as Desired Rank Resident Table Order By Date asc;
hi Anil,
Thanks for quick reply if there are two or more products then the number is not correct
You meant as follows?
hi anil,
Please find the updated excel.
Perhaps this?
Table:
LOAD Date,
Category,
Product,
Flag
FROM
[Comm1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join
Load *, If(Flag<>0, AutoNumber(RecNo(), Product), '') as Dense_Rank Resident Table Order By Date desc;