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
raisurrahman
Helper II
Helper IITimahake8Is the blank column from output table intentional or accidental?