Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Identity column

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

1 Solution

Accepted Solutions

Re: Identity column

Hi,

    

     Try this,

     Load *, rowno() as uniqueIdentifier;

     Load * from [FileName].xls

     Hope it helps.

2 Replies
mphekin12
Valued Contributor

Re: Identity column

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

Re: Identity column

Hi,

    

     Try this,

     Load *, rowno() as uniqueIdentifier;

     Load * from [FileName].xls

     Hope it helps.

Community Browser