Multiple Joins

[Anonymous]

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]

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.