topic Select from two qvd tables ??? in QlikView

Select from two qvd tables ???

Tue, 08 Sep 2009 01:03:41 GMT

Dear all,

I'm trying to use a select starting from two qvd tables files. Is it a possible option or is it not allowed ? When I try to upload data Qlik goes blocked....

Thanks Giovanni

Strutture:

.......

KEY_SPE_STRUTT AS KEY_SPE_STRUTT_1,

Store

* from Strutture into Strutture.qvd;

Esame_x_Struttura_Temp:

...... P2SPE_ESAST

&'-'& P2STR_ESAST AS KEY_SPE_STRUTT_2,

Store

* from Esame_x_Struttura_Temp into Esame_x_Struttura.qvd;

SELECT

KEY_SPE_STRUTT_2,

Strutture.KEY_SPE_STRUTT_1

..........

FROM

Esame_x_Struttura.qvd (qvd), Strutture.qvd (qvd)

WHERE

Strutture.KEY_SPE_STRUTT_1 = Esame_x_Struttura_Temp.KEY_SPE_STRUTT_2;

Select from two qvd tables ???

Oleg_Troyansky — Tue, 08 Sep 2009 02:25:35 GMT

Giovanni,

no, this syntax is incorrect - you are approaching QlikView load just like a SQL load, but it doesn't work this way. In QlikVview you load QVD files one at a time, and you can use function "exists" if you want to limit data loaded from the second table based on a key field loaded from the first table. Something along the lines:


load * from File1.qvd (qvd);
load * from File2.qvd (qvd)
where exists (Key1)
;

You also want to avoid renaming in your load (better rename the fields before you write the QVD, if possible), and you want your join key to be called the same, and that will facilitate the "natural join". If you really want to end up with a single table, you can use "Left Join" prefic for the second load, and the data will get loaded into the first loaded table.

cheers!

Select from two qvd tables ???

Tue, 08 Sep 2009 03:31:27 GMT

Thanks.

I will try tomorrow.

Bye

Giovanni