I would be really thankful if anybody could me with the issue I faced with pivoting node. The issue is I have some row data with some 0 values and when I am executing the pivoting node, those 0 values will not show up in the output table. Could anybody suggest troubleshooting steps to solve this issue?
Please also let me know if you need any more details,
handling of missing values in Pivoting node depends on aggregation method you are using and it’s settings. But it would be best to share workflow example. If your data is confidential use some dummy data to show us your problem.
I think Missing Value node could actually help me here. But I am actually changing my question because I think I didn’t explain it properly. The thing is I have a report template that should be populated with input data, and there could be cases that some record type is not present in the input data and that should be reported as 0 in the template. I know that Missing Value node will not create me those records, but it indeed helped me with rest of the data where I had missing values.
Do you think that there is a way to handle this issue?
one option is to create a dummy table by
a) using groupby node to generate unique table entries for all your row condition of your pivot table.
b) using groupby node to generate unique table entries for all your column condition of your pivot table.
c) use cross joiner on both goup by results to get all possible rows.
d) join your initial table with left outer join setting to your cross joiner result.
e) apply missing value node
d) pivot your results.