Forum Discussion
thinkpad
2 years agoRegular Visitor
Difference between Choose columns and Remove Columns in Power query
Hi Experts, Could anyone please tell me the difference between Choose Columns and Remove columns in Power Query. I'm very confused and seeing the same output. apprecaite help.
- 2 years ago
thinkpad as always the answer is "it depends..."
A simple example, when using Table.SelectColumns any "new columns" won't be included automatically whereas with Table.RemoveColumns they will. That is the choice you have to make.
Of course, that's without taking dynamic column name lists into consideration...
I hope this is helpful
thinkpad
2 years agoRegular Visitor
Thanks Mate..