Batch macro: The field “[field_name]” is missing. Compare the tool configuration...

[carrera]

Hello all,

I have a problem with a batch macro. Attached the workflow and the input files.
I am trying to make a case distinction for all csv files with the macro using the multi row formula tool.

My goal is to get in principle exactly the same format as with the input fields. However, they have dynamic fields which makes the whole thing difficult.

I have two problems:
1) I always get this error message (main issue...)

2) I would also like to take the first row from the original csv dynamically for the outputs. here I tried to work with select records. But that doesn't fit with the join at the end... (only secondary)

Can someone help me out here?

[PangHC]

you need uncheck in the input tool in macro. First Row contains field names. so it will not take first row as header.

[Qiu · Accepted solution]

@carrera 
There are several things I felt strange.

1. Macro should have a Output

2. Seems you need a Dynamic input, to read data by the Path from Macro Input

3. The filed names are different among files, so something needs to be done.