Forum Discussion
Appending two table within power query, in a way that duplicate is not created for a specific column
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
Helper IIIs it your desired format?
I assume the blank column is unintentional.
let
Source = Table.Combine({Table1, Table2, Table3}),
#"Added Conditional Column" = Table.AddColumn(Source, "Test1", each if [Map] = "Map 1" then [Test] else null),
#"Removed Columns" = Table.RemoveColumns(#"Added Conditional Column",{"Test"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Month_Year", "City", "Test1", "Map", "Amount", "Colour Rag"}),
#"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Test1", "Test"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Month_Year", type date}, {"City", type text}, {"Test", Int64.Type}, {"Map", type text}, {"Amount", Percentage.Type}, {"Colour Rag", type text}})
in
#"Changed Type"I’ve loaded all three tables as connection-only queries. In Table2 and Table3, I renamed the last column header from Red to Colour Rag. If needed, header renaming can be made user-defined for greater flexibility.
v-aatheequeCommunity Support
Hi Timahake8
Just checking in to see if the previous response helped resolve your issue shared by raisurrahman . If not, feel free to share your questions and we’ll be glad to assist.- v-aatheeque
Hi Timahake8
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.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