Forum Discussion
Data Duplicating rows after merge
Hello StephenK2022 ,
Thanks for the explanation, I have another question right now, what is the key of the new table because for example let we have the following table
if the key of my tables are columns: colA and colB, when I use the following selection and right click
I get the following result,
meaning that the key columns of my new tables are colA and colB so as long this combination of values is not reappearing in the dataset, the others will be removed. As you can see the second row with the duplication of 123, x was removed in the second appearing.
I hope this helps a little bit.
Kind regards,
Stefani Vileva
Hi Stefani,
Thanks for your reply.
The goal of the merge is to combine two data sets so that the "Number up.No up" column matches the "Job code" column.
The number up column is held in a different file and I want to match it to job code so that I can use it for a calculation.
The problem with removing duplicates through power query is that some rows have similar data.
There might be 2 separate entries that have the same values but at different times.
Also, some timestamps are the same as well but have different data:
Resolver IIHello StephenK2022 ,
Thanks for the explanation, I have another question right now, what is the key of the new table because for example let we have the following table
if the key of my tables are columns: colA and colB, when I use the following selection and right click
I get the following result,
meaning that the key columns of my new tables are colA and colB so as long this combination of values is not reappearing in the dataset, the others will be removed. As you can see the second row with the duplication of 123, x was removed in the second appearing.
I hope this helps a little bit.
Kind regards,
Stefani Vileva