topic Re: Program to automate file reading from folders in QlikView

Program to automate file reading from folders

shannoypaul — Sun, 09 Jul 2017 17:28:08 GMT

Folder Table:

FolderName

6709

6683

6893

5567

File Folder Structure would be as follows:

Source

FolderName

ORDER-FolderName.csv

SALES-FolderName.csv

PARTS-FolderName.csv

BUYER-FolderName.csv

REP-FolderName.csv

Example:

Source

6709

ORDER-6709.csv

SALES-6709.csv

PARTS-6709.csv

BUYER-6709.csv

REP-6709.csv

6683

ORDER-6709.csv

SALES-6709.csv

PARTS-6709.csv

BUYER-6709.csv

REP-6709.csv

Source\6709\ORDER-6709.csv

Source\6709\SALES-6709.csv

Source\6709\PARTS-6709.csv

Source\6709\BUYER-6709.csv

Source\6709\REP-6709.csv

I have to write a program to go through all Folders listed in the FolderName Field.

Re: Program to automate file reading from folders

Anil_Babu_Samineni — Sun, 09 Jul 2017 17:38:19 GMT

You can use some thing like below

Load * From Source\6709\*.csv

Re: Program to automate file reading from folders

shannoypaul — Sun, 09 Jul 2017 17:52:22 GMT

Wildcard will only help me read all files from the folder "6709". I want it to further pick files from subsequent folders i.e. 6683, 6893 and so on.

Since the files would have a standard format I want to use one single Load statement for the entire iteration of folders/files.

Thanks!

Re: Program to automate file reading from folders

Anonymous — Mon, 10 Jul 2017 21:51:16 GMT

I've never tried this but have you tried:

load *

from

Source\*\*.csv;

Otherwise if you have a table of all the folders you can create a loop.

Something like below. I haven't tested it but it should work.

FolderTable:

LOAD * INLINE [

FolderName

6709

6683

6893

5567

];

For Each vFolder in FieldValueList('FolderName')

let vFileName = chr(39) & 'Source\' & vFolder & '\*.csv'& chr(39);

FileLoads:

Load *

from

$(vFileName)

(txt, codepage is 1252, no labels, delimiter is ',', msq);

Next;