Unpivot Other Columns Skips Columns with nulls

[WishAskedSooner]

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!

[Ahmedx · Accepted solution]

refer to the following

https://gorilla.bi/power-query/unpivot-and-keep-null-values/

[WishAskedSooner]

@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.