Pivoting node

Good day Knime community!

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,

Many thanks,

hi @Ulzhan

Do you mean “0” of “NULL” or “?”. In case of “?” a missing value use the Missing Value node. Otherwise use a Rule Engine to give your 0-values some value.
gr. Hans

Hi @HansS,

It is missing values “?” and I want them to show up as 0 in the output table.

I used Missing Values node as you suggested and set that to String - Value - 0. But it still gives me a message “Column still contains missing values.”.

Hello @Ulzhan,

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.


1 Like

Did you the second tab in the Missing Value Node?

Hey @HansS,

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?


Hello @Ulzhan,

maybe this topics helps:


Hi @Ulzhan,

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.


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.