Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
2 years ago
Solved

Unpivot Other Columns Skips Columns with nulls

Hi Power Query Experts! I am a new user and still learning, so I really appreciate your help.

 

I have a table that I am unpivoting. There are columns in the table that have no values i.e. all nulls. When I execute the following command:

 

Table.UnpivotOtherColumns(MyTable, Keys, "Attr", "Value")

 

It skips the columns that have nulls. According to the wiki, there are no additional parameters for the above function to prevent this behavior. Therefore, what should I do because I actually need the unpivot to include the null columns for my workflow?

 

Thanks so much!

Need Help

2 Replies

    • WishAskedSooner's avatar
      WishAskedSooner
      Continued Contributor
      2 years ago

      Ahmedx Thank you so much for your quick response! I went home last night thinking that I would probably have to implement a solution similar to the link you posted. I knew that was one workaround. I just hoping that there was something easier. Microsoft really needs to add "keep nulls" as an optional parameter to the Unpivot function. The default behavior is non-best practice in my mind. Leave it to the data scientist to determine if he/she wants to filter the nulls out after unpivoting. My worflows are pretty cumbersome and having to add additional steps like these just puts additional strains on my workflows. Sigh.