Forum Discussion
Adding a key to a table
Hi, I have a PBIX that contains several tables that were imported from Excel files. Each week I append data to these tables. I didn't anticipate duplicates within the table. The main key is a pat...
Simple suggestion: In your report, model view, edit the query to your Excel file. With it displayed click the table button (top left of grid) and look for add index. This separates it from your data and makes it a per row --letting you have duplicated pat_id fields without complaint. It then falls to you how to group and handle those results.
From 0 gets 0,1,2,3 etc
Does that do what you are looking for?
scottostanek Thank you for your reply. This isn't want I am looking for. To maybe explain it better, I am looking to create a composite key that contains the pat_ID and the RunDate. That will make each record coming in unique. I hope that makes more sense.