Help with Batch Macro for multiple TXT files w/differ schema

Question

Hi all,

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.

275397 · Answer

Hi, I too am running into same issue. Were you able to solve for this problem? If yes, could you share your solution? TIA

ELPC · Answer

This is what I have so far:

This is what is coming out of the formula tool:

This is what the macro looks like:

I'm still getting this error:  I'm not sure where I am going wrong.

ELPC · Answer

Hi, the TXT files are comma delimited.  Unfortunately, these are not my files so I let me try to mask the data to provide some sample files.