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...
You can specify specific colums during the Append step using Table.SelectColumns, as in:
Table.Combine({#"Query 1", Table.SelectColumns(#"Query 2", "Column Name")})
Hello BradZehr,
I had the same issue. I followed the same logic that your script has, but I didn't know how to write it. As far as I understand Power Query this is the most efficient way to do what Anonymous wanted to achieve. Thank you for your help! Already implemented your code and works perfectly 😄
Super kudo for you 👍