I am trying to figure out how to create a batch macro to pull in all the TXT files from a particular directory. The TXT files may have some of the same fields and others will have extra columns - therefore different schema. In the actual workflow, I am assuming I will use a Directory tool first, but I am not sure what to do after that. Do I need a Dynamic Input tool after the Directory tool and then add the batch macro after the Dynamic Input? I am not sure how to configure everything. If it is a TXT file, I'm assuming I don't need to define a "sheet" like an Excel file, correct? If someone could refer to me to workflow with a connected batch macro that would be great. I tried looking all around and a lot of the batch macros I have found are for Excel files and not TXT. Thanks.
Thanks, I will take a look but again, it is an example based upon Excel files that require a sheet name. I am uncertain if I need to include a sheet name in the fullpath for the batch macro for a TXT file. Do you know? I have created a batch macro for Excel files before that worked but I just can't get it to work for TXT files. That is why I'm asking if someone can direct me to a specific example for TXT files.
