Forum Discussion
How to append only specified columns?
Hi, I am appending several tables into 1 big table. I don't need all the columns so I have manually deleted the unnecessary columns after the append. Please can you tell me how to specify which c...
Appending as new (otherwise you could start at second step and add to an existing query):
let
Source = Table.SelectColumns(Table1,{"Column1"}),
#"Appended Query" = Table.Combine({Source, Table.SelectColumns(Table2,{"MatchingColumn"})}),
#"Removed Duplicates" = Table.Distinct(#"AppendedQuery", {"Column1"})
in
#"Removed Duplicates"
You can test it with an index column (sort descending).