Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

evansabres
Valued Contributor

Loop Script for .txt files

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

1 Solution

Accepted Solutions
atkinsow
Valued Contributor II

Re: Loop Script for .txt files

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

View solution in original post

3 Replies
mwoolf
Honored Contributor II

Re: Loop Script for .txt files

why use a loop?

Load Path\*.txt

.......

evansabres
Valued Contributor

Re: Loop Script for .txt files

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

atkinsow
Valued Contributor II

Re: Loop Script for .txt files

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

View solution in original post