Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

How to perform left join?

Hello There,

How to make left join in QLikview if I have one qvd file and one excel file?

Best,

Siva

2 Replies
gaurav2017
Creator II
Creator II

Dear Can you attach the sample ???

jagan
Luminary Alumni
Luminary Alumni

Hi Siva,

Try like this

QVDTableName:

LOAD

     *

FROM QVDFileName;

LEFT JOIN (QVDTableName)

LOAD

     *

FROM ExcelFileName;

Note: The column which you want to join should have the same name on both the tables.

Hope this helps you.

Regards,

Jagan.