how to read multiple text files from a directory?

[_arun_gurubaramurugeshan]

I have a a set of text files in a directory and I would like to read everything at once instead of using mutliple input tool.

[MattH · Accepted solution]

Hi Arun, you have a few options available to you.  With a wildcard, you can read in multiple files using the Input tool.  For example, C:<file-path>*.txt.  You can also do the same with the Directory tool and the Dynamic Input tool.  In both cases, you will need to make sure that all files have the same schema, or they will not be read in correctly.

If the schema is going to be different, then your best option may be to create a Batch Macro to input all of the files.  In the Batch Macro tab, set the Output Mode to Auto Configure by Name.  This will line up all fields with corresponding names and append the input with the extra fields.

[_arun_gurubaramurugeshan]

Thanks, it worked.

[EYamada]

Can I use a wildcard if mutliple .xls files all have the same scheme, but have multiple sheets?

[TylerN]

Hey EYamada. Take a look at this solution as I believe it will work for you. I've used a slight variation successfully myself.

[EYamada]

Thank you TylerN.  A directory tool followed by two Dyanmic Inputs worked perfectly. 

[TylerN]

Awesome, I'm glad it worked for you EYamada.

[nitin_ks]

I have the similar requirement , but my files have mismatched number of columns and mismatched columns names i need . I need to process each file , get specific columns and generate output file for each input

i tried setting up the following

dir —-> macro [ macroinput(fullpath) —-> dynamicInput—-> formula —- select —> macro output]   —-> outputtool

but dynamic tool complains that second file has mismatched columns , i thought putting in macro would do it

please help