Load same times 3 txt

[pgalvezt]

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!

[rustyfishbones · Accepted solution]

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

[MK_QSL]

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.

[rustyfishbones]

there is also a video on youtube called

QlikView - Loading Data From Multiple Files - YouTube

I hope that helps

[aveeeeeee7en]

Hi Pablo

Make Flags for each Table:

eg.

Table 1:

Load

A,

B,

'1' AS Flag

Concatenate

Table 2:

Load 

A,

B,

'2' AS Flag

Concatenate

Table 3:

Load 

A,

B,

'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

[pgalvezt]

Thank you very much!

[rustyfishbones]

Your Welcome