How to perform left join?

[siva_boggarapu]

Hello There,

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

Best,

Siva

[gaurav2017]

Dear Can you attach the sample ???

[jagan]

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.