topic Loading multiple qvd files into one table in QlikView

Loading multiple qvd files into one table

Mon, 02 Jun 2014 13:34:48 GMT

In my data model I am taking several qvd files created in my extract, and loading them into the same table. For some reason qlikview is creating a separate table for each qvd rather than just concatenating them onto each other. Is there a keyword that I can use in the code shown to prevent qlikview from creating multiple tables for each qvd? Thanks.

Table1:

LOAD

Field1,

Field2,

Field3

FROM

Table1\Table1_*.qvd(qvd);

Table2:

Inner Keep (Table1)

LOAD

Field1,

Field4,

Field5

FROM

Table2\Table2_*.qvd(qvd);

Re: Loading multiple qvd files into one table

Mon, 02 Jun 2014 13:36:05 GMT

concatenate

Re: Loading multiple qvd files into one table

ashfaq_haseeb — Mon, 02 Jun 2014 13:37:41 GMT

Hi try below

Table1:

LOAD

Field1,

Field2,

Field3

FROM

Table1\Table1_*.qvd(qvd);

concatenate

Table2:

Inner Keep (Table1)

LOAD

Field1,

Field4,

Field5

FROM

Table2\Table2_*.qvd(qvd);

Modified

Hi try below

Table1:

LOAD

Field1,

Field2,

Field3

FROM

Table1\Table1_*.qvd(qvd);

concatenate (Table1)

LOAD

Field1,

Field4,

Field5

FROM

Table2\Table2_*.qvd(qvd);

Re: Loading multiple qvd files into one table

Mon, 02 Jun 2014 13:39:48 GMT

This is giving me an 'illegal combination of prefixes error'

Also, I am not trying to concatenate Table1 onto Table2. I just want there not to be multiple of each of these tables.

Re: Loading multiple qvd files into one table

ashfaq_haseeb — Mon, 02 Jun 2014 13:41:56 GMT

Hi try this

Table1:

LOAD

Field1,

Field2,

Field3

FROM

Table1\Table1_*.qvd(qvd);

concatenate (Table1)

LOAD

Field1,

Field4,

Field5

FROM

Table2\Table2_*.qvd(qvd);

Regards

ASHFAQ

Re: Loading multiple qvd files into one table

ThornOfCrowns — Mon, 02 Jun 2014 13:45:56 GMT

Are you trying to concatenate crosstables?

Re: Loading multiple qvd files into one table

rbecher — Mon, 02 Jun 2014 13:48:26 GMT

I think you have to load all QVDs into Table2 (probalby with NoConcatenate prefix) first before you can use KEEP on Table1..

- Ralf

Re: Loading multiple qvd files into one table

richard_pearce6 — Mon, 02 Jun 2014 13:49:02 GMT

Loose the 'KEEP', that keeps them as separate tables

Re: Loading multiple qvd files into one table

Clever_Anjos — Mon, 02 Jun 2014 13:56:44 GMT

You can´t use a INNER KEEP (or JOIN) while using wildcards into FROM clause

Re: Loading multiple qvd files into one table

Mon, 02 Jun 2014 13:57:47 GMT

I think your problem should be a little better described.

One cause could be that tables dont have the same structure (field names and types...).

I dont know how exactly this way of loading with a star in file path works, but you can try different way.
Try with a loop, lists all the files, save them in a variable and then in a loop load data from these qvd-s. (just my proposal)

According to the rules, should QV automaticly concetane this tables, if the format of the tables match.

Re: Loading multiple qvd files into one table

PradeepReddy — Mon, 02 Jun 2014 14:09:26 GMT

Keep - retains the tables as it is with the resultant rows.

We can achieve this using

1) Left/Right/Inner Join

Check the Parent-Child relation ship and join the tables based on the primary keys.

2) Concatinate

Regards,

Pradeep

Re: Loading multiple qvd files into one table

jlongoria — Tue, 03 Jun 2014 16:16:35 GMT

This doesn't necessarily address your question, but I would recommend reading the article below. It proved to be quite helpful for me.

Understanding Join, Keep and Concatenate

Re: Loading multiple qvd files into one table

erikzions — Tue, 03 Jun 2014 16:26:02 GMT

You more than likely have some Qualify applied. This is making a different table for each load. The * in your load is creating a loop. Thus each QVD is making a new qualified table. Try adding a Unqualify * before your load. Then if you still need it qualified, load into a second table afterwards.