Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Combining several text files into a single file

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 Replies
Highlighted
Not applicable

Re: Combining several text files into a single file

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.

Highlighted
Not applicable

Re: Combining several text files into a single file

Yes it works, thanks a lot.

Regards,

Marie Joelle