Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor
Partner - Contributor

No unique identifiers in table

Hey guys, 

So I have a table that lists multiple product orders for multiple stores. The fields in the table include all kinds of information regarding the seller type, buyer type, product type, etc... However there is absolutely no unique IDs in this table. 

This is an issue since I am trying to make a unique identifier for each overall store transaction (not for each individual product bought). I don't want to touch the data load editor.

Is there a way for me to create a master item dimension that serves as a unique key for each transaction. I want to create a master item that combines multiple dimensions in order to create a unique identifier. How do I write this expression?

Labels (1)
  • SaaS

3 Replies
Luminary Alumni
Luminary Alumni

Can you give a little more information. For example--a sample of the data?

Partner - Contributor II
Partner - Contributor II

Product order and region code

Champion III
Champion III

you can use Recno() as below while loading data, to identify each record separately

RecNo()  as ID  

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.