Forum Discussion
Creating my own primary keys. Data source has none.
I would enjoy anyone's opinion on using addIndex in Query Editor to use as a primary key in my dimEmployee table and dimVendor table, respectively. The data source is an Excel file that comes from a...
What you are proposing is fine, assuming that the correct index # gets assigned in related tables each refresh. It is not required to have an index if you don't need one. Many people just use existing fields, and often people concatenate 2+ existing fields to create a key column with the right granularity. In any case, new index #s each refresh is no problem.
If this solution meets your need, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat