Need unique id for each record

[#1]

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.

[SunilChauhan]

can you be more specific with your requirement.

as u already have unique id.

[#3]

Hi,

Try with autonumber function

autonumber(expression[ , AutoID] )

Hope this will help you.

Thanks & Regards

Upendra

[#4]

II think Antony with the picture illustrates how he wants it to look like.

Try function:

rowno().

Load Year,

rowno() as ID;

FROM ......

/Danne

[#5]

I tried by autonumber an Rowno() but its not coming....

[#6]

Hi Sunil,

I have given an example on above....

[#7]

Hi Upendra/Danne,

         Can you send an example application.

[#8]

This should work:

LOAD RowNo() as ID,

          Num(Year(CREATED),'00','####') as Year;

SQL SELECT *

FROM  Table X;

[#9]

Hi,

try with this:

LOAD

RecNo() as ID,

...

regards