Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a file with a list of dates
Load
PIN
Application_Medium
Application_date
FROM
(ooxml, embedded labels, table is [Results]);
Is there an autonumber function i can use to assign a sequential number to each date starting from lowest to highest? So for example
Date | Date # |
---|---|
01/01/2016 | 1 |
01/02/2016 | 2 |
01/03/2016 | 3 |
01/04/2016 | 4 |
Sure, you can try
AutoNumber(Application_date) as Date#
but you will have to make sure that the table is sorted in the ascending order of Application_date to give the correct sort order. Sorting (using Order By) can only be done in Resident load.
Something along these lines:
Table:
LOAD PIN
Application_Medium
Application_date
FROM
(ooxml, embedded labels, table is [Results]);
FinalTable:
LOAD *,
AutoNumber(Application_date) as Date#
Resident Table
Order By Application_date;
DROP Table Table;
Sure, you can try
AutoNumber(Application_date) as Date#
but you will have to make sure that the table is sorted in the ascending order of Application_date to give the correct sort order. Sorting (using Order By) can only be done in Resident load.
Something along these lines:
Table:
LOAD PIN
Application_Medium
Application_date
FROM
(ooxml, embedded labels, table is [Results]);
FinalTable:
LOAD *,
AutoNumber(Application_date) as Date#
Resident Table
Order By Application_date;
DROP Table Table;