topic Re: Loop Script for .txt files in QlikView

Loop Script for .txt files

evansabres — Thu, 20 Jul 2017 17:35:33 GMT

I have roughly 120 .txt files in a folder, each with three fields,'Name,' 'Male' and 'Female'

I want to load all 120 files into an application.

I have done a loop script for an excel file with multiple sheets, but not for .txt files.

What is the syntax for this script.

Thank you

m_woolf — Thu, 20 Jul 2017 17:38:20 GMT

why use a loop?

Load Path\*.txt

.......

evansabres — Thu, 20 Jul 2017 17:39:09 GMT

What would the structure of the script look like to load all of the files in the folder?

Anonymous — Thu, 20 Jul 2017 17:51:03 GMT

Something like this.

Load

Name,

Male,

Female

From YourFIlePath\YourFolder\*.txt;

Use the wizard to pull in one and change your From string to end with *.txt