Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Left join correction needed in the script

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.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
VishalWaghole
Specialist II
Specialist II

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III

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