Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you give a little more information. For example--a sample of the data?
Product order and region code
you can use Recno() as below while loading data, to identify each record separately
RecNo() as ID