Forum Discussion
Addressing Partial Duplicates
Anonymous , to fix this we need something unique. Like in sample data customer name is unique. You can add an index column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Starting with 100. in first table
and then you can merge two tables on customer name
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thanks for advice amitchandak , BA_Pete . I have simplified the table to convey a problem involving partial table, and duplication as error entry. The CustomerID is used as record identifer for an evolving Table and some CustomerID have errors , my thought is to simplify flow and correct CustomerID to be use as identifier. This CustomerID is just like an Social Security No. which is supposed to be distinct and unique.
1) The new index column may work us single out unique entry but I probably have to figure out a way to ReplaceValue for CustomerID errors.
2) Concatenate CustomerID & Name probably wont work if I need to index to other table using CustomerID.
Anonymous ,
OK, so it looks like you really need to get to the root cause of why some of your [CustomerID] are showing as errors. Are the errors generated by Power Query, or are the errors in the data source and are being pulled into Power Query?
If you're not sure, select one of the error cells in Power Query and share a screenshot of what the errors look like. Please remove any sensitive information from your screenshot.
Next, you need to look at whether you can bring [CustomerID] into your CustomerDetails table. If [CustomerID] exists in the system I would assume that it would feature in the CustomerDetails table. From there, a simple merge will get you what you need.
Pete
