How to load multiple months of data field into a single table in Qlikview?

[#1]

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?

[Gysbert_Wassenaar]

Can you post the load script that's giving your trouble?

[#3]

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.

[Gysbert_Wassenaar · Accepted solution]

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;

[jsanchezh]

If they have the same field names and information you can use

Table:

Load

     ...

From ;

concatenate (Table) Load ...

From ;              

and so on                ...

[#6]

Thanks. I will give it a try!

[#7]

Thanks. I will give it a try!

[#8]

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?

[Anonymous]

Are you sure there are many months of data?  Maybe the files are the same just the file names are different (???)

[maxgro]

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];