Combining several text files into a single file

[#1]

Hi everyone,

I would like to use Qlikview to combine several text files into a single file to be able to analyse and use the data for some charts.

How should I proceed ?

Thanks for your help!

Marie Joelle

[#2]

Hi Marie,

If you have multiple files which have the same columns to be loaded into qlikview the following would help you.

for each File in filelist (<filepath>&' \*.txt') 
          Load * From $(File)
          (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
next File

Regards,

Kiran Rokkam.

[#3]

Yes it works, thanks a lot.

Regards,

Marie Joelle