topic Combining several text files into a single file in QlikView

Combining several text files into a single file

Wed, 04 Jul 2012 16:43:47 GMT

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

Re: Combining several text files into a single file

Wed, 04 Jul 2012 17:26:59 GMT

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.

Re: Combining several text files into a single file

Thu, 05 Jul 2012 09:51:09 GMT

Yes it works, thanks a lot.

Regards,

Marie Joelle