Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sz4392
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
lblumenfeld
Partner Ambassador
Partner Ambassador

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

James1997
Partner - Contributor II
Partner - Contributor II

Product order and region code

vinieme12
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.