Left join correction needed in the script

[bhavvibudagam]

Hi Experts,

can any one please help me on this.

In the below script I am doing left join to Target table from 2 tables by taking resident with Capability_Actuals,Coverage_Actuals

but only first left join with Capability_Actuals is working second left join with Coverage_Actuals is not working.

[VishalWaghole]

It might be possible your coverage_actual table get auto contact to capability_actual.

Can you please use no concatenation word before to coverage_actual table.

Thanks,

Vishal

[rwunderlich · Accepted solution]

instead of loading a separate table for Coverage_Actuals, concatenate this data on to Capability_Actuals. And then do a single join from Capability_Actuals.

-Rob

[Monicalingan]

Hi try this,

Join Capability_Actuals and Coverage_Actuals then left join with target table

See below sample

Monthname:

LOAD * INLINE [

    MonthNo, Monthnameshort

    1, Jan

    2, Feb

    3, Mar

    4, Apr

    5, May

    6, Jun

];

TempJoin:

LOAD * INLINE [

    MonthNo, Monthnamelong

    1, January

    2, February

    3, March

];

Join

LOAD * INLINE [

    MonthNo, Monthnamelong

    4, April

    5, May

    6, June 

];

Left Join(Monthname)

Load *

Resident TempJoin

Order by MonthNo;

Drop table TempJoin;

Hope it helps.

Thanks,

Monica