topic Join data from a QVD to data from SQL Table in QlikView

Join data from a QVD to data from SQL Table

Fri, 06 Apr 2012 15:19:48 GMT

Hi,

Is there anyway to Join daata coming from a QVD File to data coming from SQL Query?

Thxs

jagan — Fri, 06 Apr 2012 15:22:48 GMT

Hi,

Try like this

Table1:

SQL Select KeyField, * from tableName;

LEFT JOIN(Table1)

LOAD

KeyField,

FROM FileName.QVD;

Hope this helps you.

Regards,

Jagan.

Fri, 06 Apr 2012 16:35:03 GMT

Great help..

Thxs