Forum Discussion
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"}, "Attribute", "Value")
No Matter when my table contains data, but if I there are no data in it, I've got this error:
Expression.Error: The argument value isn't valid.
Details:
[List]
How could I avoid this error when the table is empty?
Thanks a lot in advance for any clue!
= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")
1 Reply
= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")