Forum Discussion
Power Query delete/change values in existing column
Hello friends,
How can I delete all values in existing column? Without deleting it and creating a new, empty one?
Another question is: how do I change all different values in an existing column to some specific value? Also without creating a new column?
Thank you
Michael
This will change all values in Column2 of table Source to null.
Adjust as required.
= Table.TransformColumns(Source,{{"Column2", each null}})
3 Replies
- MarcelBeug
Community Champion
This will change all values in Column2 of table Source to null.
Adjust as required.
= Table.TransformColumns(Source,{{"Column2", each null}}) Thank you. I have used it also.
