Forum Discussion
Difference between Choose columns and Remove Columns in Power query
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
Thanks mate for the response. But under which situations we should go for Choose or Remove Columns?
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