Forum Discussion
ValeriaBreve
Post Partisan
4 years agoReplace non null values in a column with column title
Hello,
I was wondering how to replace non null values in a column with the column title, what would be the best code to do this?
Thanks!
Kind regards
Valeria
=Table.TransformColumns(PreviousStepName,{"ColumnName",each if _=null then _ else "ColumnName"})
2 Replies
- wdx223_Daniel
Community Champion
=Table.TransformColumns(PreviousStepName,{"ColumnName",each if _=null then _ else "ColumnName"})
- ValeriaBreve
Post Partisan
thank you!