Forum Discussion
Solved
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...
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.
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
