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...
RenaG Potentially. You could probably create a function or otherwise extract the file creation date or what not and include that as a column in your tables. You could then create a unique key from that and your pat_ID field. Specifics are going to vary. Are you using a Folder query?
Greg_Deckler I was wondering if you had any other thoughts on this question. I can create a composite column with the pat_id and run date. I don't know how to indicate that field is the unique key. Can you explain that process? Thanks!