Easiest way to add key to a table

[#1]

I simply want to add a primary key to each of these distinct YearEvents:

like so:

Key     YearEvent

0          2010 Comittee

1          2009 WTS

2          2012 Podium Speaker

...         ...

...         ...

101       2012 WTS

I know I can do this with a for loop but I feel like there is a much easier way to accomplish this. I feel like I'm brainfarting on this, either way, any help would be greatly appreciated.

[#2]

did you check the autonumber()?

[joshabbott · Accepted solution]

how about adding 'rowno() as id' as a column in your script?

[ecolomer]

Can you try with:

LOAD

     RecNo(),

    YearEvent

from FILE;

[ecolomer]

You can use also RecNo()

[ecolomer]

And RowNo()