Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need unique id for each record in year field.
Eg:
Year ID
2009 - 2010 1
2010 - 2011 2
2011 - 2012 3
Can any one help me.
Thanks,
Antony.
can you be more specific with your requirement.
as u already have unique id.
II think Antony with the picture illustrates how he wants it to look like.
Try function:
rowno().
Load Year,
rowno() as ID;
FROM ......
/Danne
I tried by autonumber an Rowno() but its not coming....
Hi Sunil,
I have given an example on above....
Hi Upendra/Danne,
Can you send an example application.
This should work:
LOAD RowNo() as ID,
Num(Year(CREATED),'00','####') as Year;
SQL SELECT *
FROM Table X;
Hi,
try with this:
LOAD
RecNo() as ID,
...
regards