Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Replace 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
  • wdx223_Daniel's avatar
    4 years ago

    =Table.TransformColumns(PreviousStepName,{"ColumnName",each if _=null then _ else "ColumnName"})