Forum Discussion
Disappearing values after Unpivot Table
Hello,
I am trying to do the following Unpivot:
I select column A (Supplier) and B (Doc Number) and I select Unpivot other columns.
So the final result is Supplier, Doc Number, Invoice Type and Value. However, when I do this the first, for example, 600 rows referring to column B (Doc Number) disappears. Can anyone help this newbie to understant what I am doing wrong? Thank you.
A B C D E F G
Supplier Doc Number Invoice Tran Invoice Ins Invoice DT Invoice FRG Invoice AT
| Sup1 | RS/21 | 12B | 13B | 12B | 14B | null |
| Sup1 | RS/22 | null | null | 20C | null | null |
| Sup2 | XPTO/1 | BG-12 | BG-1 | BG-13 | BG-14 | BG-15 |
| Sup2 | XPTO/1 | CP-13 | CP-14 | CP-15 | CP-16 | CP-17 |
You need to replace the null with some value that can be replaced to null later.
When you unpivot null values, it is removed from the dataset.
2 Replies
You need to replace the null with some value that can be replaced to null later.
When you unpivot null values, it is removed from the dataset.
Thank you.
I had to add a Dummy column with values for the lines that a had new Doc Number but have yet to receive invoices not to disappear
