Batch Macro to Read in / Append CSVs from SharePoint

Question

Hi all, I have successfully used SharePoint batch macros to read in multiple xlsx files and append into one table, however the same approach isn't working with a csv for some reason. I have tried to configure my action tool and structure my incoming file path or file name in a bunch of different ways, but no dice. Any thoughts on what I'm doing wrong here?

CSV Base File Input Configuration.png

Input for Batch Macro.png

Action Tool Configuration.png

hurleyk · Answer

For further context the macro as currently configured appends the "base" file used in the macro 8 times rather than updating the file path and reading in each of the 8 files.