In this example I want the columns with missing values not to get skipped. Although there is no value in the columns I want to show the columns in the end.
I have tried the missing value operator, but when I put it after the Excel Reader there are already no missing values in the table anymore.
Is there any possibility to adapt the “more options” and to get rid off the cross at “skip empty cokumns” (see photo attached)
have a look at the Options within the “More Options” part and uncheck “Skip empty columns” e.g.
Afterwards you can handle these missing values the Missing Value Node as you already mentioned.
*edit: However, now I see, that this part of the configuration window is grayed out. I don’t know what’s the reason for that. Can you please share your excel file?