Hello Tableau Community,
In my table containing just 3 columns, product name, product description, product manufacturer; how can I create unique product ID key by means of calculations / measures that gets assigned to teach row?
More importantly, can duplicate rows be handled when concatenating these data values?
|Product Name||Product Description||Product Manufacturer||Product ID|
|Pencil||Fine Point 0.7 mm||Zebra USA||?|
|Pencil||Fine Point 0.5 mm||Paper Mate USA||?|
|Pen||Pilot G6 07||Paper Mate USA||?|
I would like to understand if there is a way to automatically generate human readable product ID based on these 3 columns?
One of the basic ways is to understand the data really well and create look up tables so that first row gets assigned 1-1-1 product ID, second row gets assigned 1-2-2 and finally third row gets assigned 2-3-2. But I am looking for formula based technique than dealing the assignment at atomic level which is quite tedious!
Thanks in advance,