Forum Discussion
Solved
Appending two table within power query, in a way that duplicate is not created for a specific column
I want to append the first three table to create the last table. I do not want the test value for each city in a specific month to be repeated in my new table (I am trying to achieve table 4).
Hi v-aatheeque, I have been able to sort the problem in a different way. I needed the test column on my table so a could use it to filter my visual but since I could figure a way to make it work to get the ultimate result I wanted, I just applied the filtering within my model during transformation and solved it. Thank alot
vivien57
Super User
Super UserHello Timahake8 ,
Try this :
let
Source1 = Table1,
Source2 = Table2,
Source3 = Table3,
Combined = Table.Combine({Source1, Source2, Source3}),
RemoveDuplicates = Table.Distinct(Combined, {"Month_Year", "City", "Test", "Map"})
in
RemoveDuplicates
then add a column to the result table to handle not repeating the test value
Have a nice day,
Vivien
Many thanks for your assisting, this solution doesnt work for what I am trying to achieve.