Iterative Macro - Field Error

[nazrin_guliyeva]

I have the following Iterative macro:

And it runs fine. When I run my workflow, I get the following field error in the second iteration. 

From Interface Designer, I have set the output to auto-config by Name. 

Can anybody help with this how I can achieve it?

[clmc9601]

Hi @nazrin_guliyeva,

Do you deselect the field [created_at] in the select tool with the purple arrow (or at any point in the flow)? That could be causing this error.

Especially if the blue arrow formula tool is "Tool 24" and you reference [created_at] without adding the column back in. 

If that doesn't help, can you send pictures of Tool 24's Expression 1 configuration and the configuration of the select tool which I marked with a purple arrow?

[nazrin_guliyeva · Accepted solution]

Fixed the issue by creating Text Input and giving all column names and union it to my data. So in case when there is particular fields that do not exist, it will not throw an error.