topic Re: No unique identifiers in table in App Development

No unique identifiers in table

sz4392 — Sat, 13 Aug 2022 12:08:15 GMT

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?

Re: No unique identifiers in table

lblumenfeld — Sun, 14 Aug 2022 03:53:00 GMT

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

Re: No unique identifiers in table

James1997 — Sun, 14 Aug 2022 07:23:51 GMT

Product order and region code

Re: No unique identifiers in table

vinieme12 — Mon, 15 Aug 2022 06:14:09 GMT

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

RecNo() as ID