Multiple Joins

Anonymous — Wed, 02 May 2012 04:38:17 GMT

Hi guys,

here is my situation.

I am loading one table from a csv file + 2 other table from 2 excel files.

load

date, id, country, salesqty, xyz from [csv file];

load

date,name,id,country from [xls file1];

load

name,country,commission from [xls file2];

csv is the superset. I want to do a left join between csv and xls file1.

again left join between the above joined table and replace commission = 0 if null.

Help greaty appreciated.

jagan — Wed, 02 May 2012 11:54:53 GMT

Hi,

Try below example

CSV:

LOAD

FROM CSVFileName.csv;

LEFTJOIN(CSV)

LOAD

FROM ExcelFile1;

LEFT JOIN(CSV)

LOAD

FROM ExcelFile2;

Hope this helps you.

Regards,

jagan.

topic Multiple Joins in QlikView