Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have loaded multiple months of performance files into Qlikview but it is only reading the first month loaded. How do I combine the data set into one?
Add Concatenate to force loading into an existing table even if the number of fields or the names of fields of the sources are not exactly the same:
MyTable:
LOAD * FROM source1;
Concatenate(MyTable)
LOAD * FROM source2;
Can you post the load script that's giving your trouble?
There are 4 screens. There are different months of data file. Need to load everything and combine into a single table. What script do it need to write to combine it up so that I can do up the necessary tables? Appreciate your help. Cheers.
Add Concatenate to force loading into an existing table even if the number of fields or the names of fields of the sources are not exactly the same:
MyTable:
LOAD * FROM source1;
Concatenate(MyTable)
LOAD * FROM source2;
If they have the same field names and information you can use
Table:
Load
...
From
concatenate (Table) Load ...
From
and so on ...
Thanks. I will give it a try!
Thanks. I will give it a try!
Hello, I have tried but it is still ready only the first month data. Did I miss out anything?
Do I need to include anything in between the files?
Are you sure there are many months of data? Maybe the files are the same just the file names are different (???)
if your files have the same number and name of the fields you can load all the fles with asingle statement using wildcard (* ?)
LOAD *
FROM
[$(vPATH)On_Time_On_Time_Performance_20??_??.csv];