Select from two qvd tables ???

[#1]

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;

[Oleg_Troyansky]

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!

[#3]

Thanks.

I will try tomorrow.

Bye

Giovanni