Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join data from a QVD to data from SQL Table

Hi,

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

Thxs

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Table1:

SQL Select KeyField, * from tableName;

LEFT JOIN(Table1)

LOAD

     KeyField,

     *

FROM FileName.QVD;

Hope this helps you.

Regards,

Jagan.

View solution in original post

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Table1:

SQL Select KeyField, * from tableName;

LEFT JOIN(Table1)

LOAD

     KeyField,

     *

FROM FileName.QVD;

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Great help..

Thxs