Batch macro to union multiple files not working

[fiddycodes]

Hello, 

I'm using a batch macro to read several csv files from a list of directories and union them together. 

filepaths

H:\Users\David\David.csv

H:\Users\Sam\new_file.csv

The schemas are different for some of the files, that's why I'm not using dynamic input. Dynamic inputs works for the files with the same schema though. Using the macro, my issue is that the macro is only reading the first input. Why is that? I'm not sure what I'm doing wrong. Here are some screenshots of my macro. 

My input table is a list of the different file paths as shown above. Please help

[Luke_C · Accepted solution]

Hi @fiddycodes 

Do you have a tool after the macro? If there's nothing after the macro only the first iteration will run. Try putting a browse tool after it. 

[fiddycodes]

Haha, what the heck? That worked! Why is that the case?

[Luke_C]

I can't find the exact documentation but that's expected behavior, probably to help performance.. i.e. only run everything if it's going to go somewhere. 

[fiddycodes]

Wow, I wish it said "showing partial results" or something

[fiddycodes]

Thank you!

[VegasBeans]

YES!! Great call - thank you @Luke_C !