Forum Discussion

laciodrom_80's avatar
laciodrom_80
Helper IV
4 years ago
Solved

Unpivoting column: problem when table is empty

Hi all,   I'm usign this UnpivotOtherColumn command in Power Query in a step of a table data transformation: = Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "At...
Need Help
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago
    = if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago
= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")