Missing Value node column setting variables

[WadeLo]

Hi Experts,

I have several columns which would use different method for missing values.

Such as columnA uses Fix Value, columnB Do Nothing, columnC use *Previous Value…

I know this can be done for static setting each column separately in Column Settings.

However, I try to use a dynamic way to adjust corresponding column in my config table and specify different method for each column.

I found I can get a new column 0 in Flow Variables once I add a column to deal with missing value in Column Settings tab.

Since I can pass the column name variable into colNames, but I cannot figure out what does the variable “FactoryID” mean?

Maybe there is a list to show the method for missing value handling?

BR,
Wade

[tark]

Hello @WadeLo ,

If you check the output for Missing value node, you might be able to figure out how to specify the Factory ID. I think if you enter a variable name in the box on the right side of the Flow variable tab, then execute missing value node, you can find the Factory ID value in flow variable tab of the output table. I’ve got a few factory IDs as follows. It might work if you set this value (although it’s a very long string) to a variable. Does this answer to your question?

[WadeLo]

Hi Tark,

Thanks for your quick reply.

This is what the answer I found.

I didn’t use output function in flow variable tab before so I cannot figure out what parameters I can set.

Thanks again!

regards,
Wade