How to add missing fields as Null when they are not present

[Gandalf_NotGrey]

Hello

I have a workflow where I am creating four fields using input data. These four fields are then used for a set of calculations. When any of these field is not present, the formula tool errors out. I want to create the missing fields and replace them as Null().

If you see the attached sample, I tried this by adding the missing fields as through a Text Input tool and Union it with the main flow. But this only works when all four fields are not present in the main workflow. In my case, one of two or three of the fields can be not present and I need to add only those ones are Null or empty. How can I do this?

Thanks.

[PhilipMannering · Accepted solution]

I think you're doing it correctly. Either delete the empty row in the dummy Text Input (or if you always want one row even if no data in the main workflow branch then you could sample the first row).

[Gandalf_NotGrey]

Thanks @PhilipMannering - I removed the empty row and it worked. Should've just kept the columns.