(SOLVED) Create column when it is not created by a pivoting node to get defined number of columns


After the pivoting node the table structure is based on the content of the table used as input.
When a value is not available in the pivot column, let’s say Y, the Y column is not created.
But I need the Y column because my table layout at the end of my workflow must have a predefined layout including the Y column.

How can I add columns when they do not exist and not adding this column when it has been created by the pivoting node?

Thanks for your help


I found a method:
Updating the domain of the column with possible values and in the pivoting node un-check the ignore domain setting.

That did the trick.


1 Like

Glad you found a way to fix it. Thanks for posting your solution!

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