Hi Please help on this I am trying to assign autonumber for days in a month
Like this...... please help on this.
If it's just for 2 months please use a INLINE LOAD as assign a auto number value.
LOAD * INLINE
This will create a auto number for dates.
Thanks for your reply that is not for 2months that is continues process.
Why not Day(Date) as autoid.
Autonumber is slow.
However syntax is like this
LOAD Date,Autonumber(Day(Date),MonthName(Date)) as autoid
If You have dates like this
If You want 02 -> 2 and 05 -> 5 then use Day(Date).
Thank-you..... Autonumber is working for me
Retrieving data ...