Create an New column if the column is missing from the input file

Question

I have a requirement where I have a input file in which there is a column named "Passed" in the data we have the count, sometimes what happens is the input doesn't have the "Passed" column, so I want to create a column named passed if the column is not present in the input file and keep the data as 0, otherwise if I have the passed column from the input I don't want any changes in the data, how can I perform this in Alteryx?

DanielvanLeuzen · Accepted Answer

There are several ways of doing this, but I would do the following.

Use the text input to create an empty row with the passed column and union this to your data. You can filter out the empty added row if necessary afterwards. I think the setting auto config by name and output all fields in the union tool should do the trick