Alteryx: How can I automatically add a field if it is not present in an incoming file??
Question ID: 109640

I am scheduling a workflow that has new daily excel files. On day 1 there are fields A, B, C, and D. I aggregate on these fields in the workflow. On day two the workflow runs again, but error out because there are only fields A and B. If any fields (in this C and D) are not present it means there is no data for that field for that day.

How can I automate this so that, even if one of these four fields is not present, every field will appear in the workflow?



Marked as spam
Posted by (Questions: 17, Answers: 0)
Asked on June 24, 2020 6:19 pm
Answers (1)
Private answer

The most concise way to do this would be to use the Ensure Fields tool from the CReW Macros (available for download here:

This tool allows the user to put one field per line and it will check if the incoming data stream contains those fields. If it contains a field, it does nothing. If it doesn't contain a field, then it adds that field with null values. You can also set the data type within the Ensure Fields tool.

See the attached photos for an example.

Marked as spam
Posted by (Questions: 0, Answers: 17)
Answered on June 25, 2020 10:42 am

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top