Forum Discussion

nhoff's avatar
nhoff
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Unpivot removes rows with no/null values - how to keep them?

When I unpivot a table, the rows with no data gets removed.   Any suggestions for how to keep the columns of rows, that are no unpivoted? In the example below, notice that Andrew has no sales and i...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Select Monday to Friday in Query Editor, Go to Transform Tab, Replace Values ---> Replace "null" with "0".

     

    You would see the expected results.

BradleyA's avatar
BradleyA
Regular Visitor
9 years ago

Nick,

 

You probably thought of this already:

 

1) replace Null with 0 or "No Value"

2) unpivot

3) replace the 0 or "No Value" with Null

Grumelo's avatar
Grumelo
Icon for Advocate II rankAdvocate II
8 years ago

I'm having the same issue.

Replacing null by a value is a workaround not the solution.

 

I don't see any reason to drop null values.

 

The column exists, the row must exist !