Unpivoting column: problem when table is empty

[laciodrom_80]

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!

[wdx223_Daniel · Accepted solution]

= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")