I would add it to the source data, then you have complete flexibility.
If this is not possible, you can create an index() calculation and untick Analysis > Aggregate Measures. If you include all dimensions, that make up a unique record, onto detail and drag your index calc to view, this will be your unique database record ID.
Thanks but it don´t resolve the question because I do not want to have all the columns in the view and need later reuse that Row ID in other sheets.
1 of 1 people found this helpful
Hi! I think you should considered to build Id row in a sql query.
You can also consider concatenate all dimmensions and str([measures]), move to row shelfs and then hide it. The problem is if you have repeated records.
The best solution I have found is to generate ID row outside Tableau. Of course, If your data exceed Excel capacity you should consider other software to prepare data.
Maybe people here can tell what software they think is the best option to prepare big data bases,
I have the same issue. I need to create a unique ROW ID outside Excel.
My data source is excel and I have two sheets. I used table join to connect these two sheets.
In sheet one I have 170000 records and in sheet 2 I have 280000 records. Since I have used table join I have duplicate lines when I used number of records to count.
In my view I need to give a count of sheet 1 ( 170000). I don't have unique ID in my data source.
Is there a way I can create unique Row id for 170000 in sheet 1 so that I can use that to count the number of records in my view.
Attach is the sample data of how my data source is connected.
Count.twbx 17.6 KB