Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
This will change all values in Column2 of table Source to null.
Adjust as required.
= Table.TransformColumns(Source,{{"Column2", each null}})