Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

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

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?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

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;


talk is cheap, supply exceeds demand
11 Replies
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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.

2nd.jpg1st.jpg

3rd.jpg

4th.jpg

MVP & Luminary
MVP & Luminary

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

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;


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

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

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

Table:

Load

     ...

From ;

concatenate (Table) Load ...

From ;              



and so on                ...

Not applicable

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

Thanks. I will give it a try!

Not applicable

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

Thanks. I will give it a try!

Not applicable

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

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?

Error.bmp

mov
Esteemed Contributor III

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

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

MVP
MVP

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

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