topic Re: Load same times 3 txt in QlikView

Load same times 3 txt

pgalvezt — Fri, 24 Jan 2014 20:16:33 GMT

Hello,

How can I Load 3 files that contain the same information. I test with concatenate and load all the same time but when I want sum all of the QlikView gives me another Sum.

Could be a Example too thanks!

Re: Load same times 3 txt

rustyfishbones — Fri, 24 Jan 2014 20:20:41 GMT

You need to use the *, so for example if the 3 files are

201401.txt

201312.txt

201311.txt

You can load all 3 text files (as long as they are located in the same folder) by saying

LOAD *

FROM YourFolder\*.txt

I hope that helps

Regards

Alan

Re: Load same times 3 txt

MK_QSL — Fri, 24 Jan 2014 20:21:02 GMT

If you want to merge them you need to either use Join if not all columns are same but in case if you have all columns are same, use concatenate.

If you want to keep all table separate use noconcatenate.

let us have the sample file for further details.

Re: Load same times 3 txt

rustyfishbones — Fri, 24 Jan 2014 20:22:48 GMT

there is also a video on youtube called

QlikView - Loading Data From Multiple Files - YouTube

I hope that helps

Re: Load same times 3 txt

aveeeeeee7en — Fri, 24 Jan 2014 20:28:38 GMT

Hi Pablo

Make Flags for each Table:

eg.

Table 1:

Load

'1' AS Flag

Concatenate

Table 2:

Load

'2' AS Flag

Concatenate

Table 3:

Load

'3' AS Flag

Reload this Table and when you are calculating the Sum use this Flag Also

eg. Sum({<Flag={'1'}>}A)

Hope it Works.

Regards

Aviral Nag

Re: Load same times 3 txt

pgalvezt — Mon, 27 Jan 2014 15:37:07 GMT

Thank you very much!

Re: Load same times 3 txt

rustyfishbones — Mon, 27 Jan 2014 15:40:39 GMT

Your Welcome