how to read multiple text files from a directory?

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.

Input

Dynamic Processing

Accepted answers

MattH

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.

All comments

MattH

_arun_gurubaramurugeshan

Thanks, it worked.

EYamada

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703