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

[Johnny_Gel]

Hello,

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
Johnny

[Johnny_Gel]

Hello,

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.

Thanks

[ScottF]

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