- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
refer to the following
https://gorilla.bi/power-query/unpivot-and-keep-null-values/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
refer to the following
https://gorilla.bi/power-query/unpivot-and-keep-null-values/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 01-05-2024 12:43 AM | ||
06-27-2024 07:55 AM | |||
11-13-2024 07:24 AM | |||
04-14-2024 07:00 PM | |||
11-17-2024 09:52 PM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |