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 ...
This will change all values in Column2 of table Source to null.
Adjust as required.
= Table.TransformColumns(Source,{{"Column2", each null}})
This will change all values in Column2 of table Source to null.
Adjust as required.
= Table.TransformColumns(Source,{{"Column2", each null}})- Exactly what I needed!
Thank you!
Michael