topic Re: Identity column in QlikView

Identity column

Thu, 21 Jun 2012 15:49:40 GMT

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 — Thu, 21 Jun 2012 15:54:30 GMT

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

MayilVahanan — Thu, 21 Jun 2012 16:04:26 GMT

Hi,

Try this,

Load *, rowno() as uniqueIdentifier;

Load * from [FileName].xls

Hope it helps.