Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need generate in script unique numbers for date field with sort by ascending.
Date
01/01/17
01/02/17
01/03/17
02/2017
02/15/17
I need
Num, Date
1, 01/01/17
2, 01/02/17
3, 01/03/17
4, 02/15/17
5, 02/2017
Thx.
You can try
Data:
Load Field1, Field2, Date From TableName;
Left Join (Date)
Load Date, AutoNumber(Date) as Num Resident Data Order By Date;
May be
AutoNumber(Date) as Num
I already tried it but sort is not ascending by date
You can try
Data:
Load Field1, Field2, Date From TableName;
Left Join (Date)
Load Date, AutoNumber(Date) as Num Resident Data Order By Date;