Solved: Identity column - Qlik Community - 363020

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

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

Hi,

Try this,

Load *, rowno() as uniqueIdentifier;

Load * from [FileName].xls

Hope it helps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies

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

Hi,

Try this,

Load *, rowno() as uniqueIdentifier;

Load * from [FileName].xls

Hope it helps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.