Identity column

[#1]

The data which I am loading (from Excel) doe not have an unique identifier on each row.

Is it possible to have QV to assign a unique integer per row?

This is to make sure my tables display correctly etc.

thanks

[mphekin12]

You could try the recno() function in your load script.

[MayilVahanan · Accepted solution]

Hi,

     Try this,

     Load *, rowno() as uniqueIdentifier;

     Load * from [FileName].xls

     Hope it helps.