Inputing a Text File using Dynamic Input Tool

[clarrock]

Hi,

If i want to input a text file what would the template? Should that be a text file as well?

Thanks,

Steve

[Luke_C]

Hi  @clarrock 

Yes, your template should be representative of the files you're looking to load. With text files this is especially important if you're configuring certain delimiters. Are you running into any issues?

[mceleavey]

Hi @clarrock ,

this is always an interesting case. As @Luke_C  pointed out, you need to choose the template that is representative of the format of the files you are dynamically loading.

However, I've built a tool that loads in multiple Excel files and gets around the problem of the schema being different. You can download that from the gallery HERE.

What this tool does is simply uses the batch macro functionality to overwrite the file being used as the template, to be the actual file you are importing each time. This means the schema always matches itself.

You can open this tool and see the methodology behind it.

I hope this helps,

M.

[Jmann3891]

This is incredibly useful.