Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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.
there is also a video on youtube called
QlikView - Loading Data From Multiple Files - YouTube
I hope that helps
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
Thank you very much!
Your Welcome