topic Re: Left join correction needed in the script in QlikView

Left join correction needed in the script

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Left join correction needed in the script

VishalWaghole — Fri, 17 Nov 2017 19:00:35 GMT

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

Re: Left join correction needed in the script

rwunderlich — Fri, 17 Nov 2017 19:35:15 GMT

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

Re: Left join correction needed in the script

Monicalingan — Sat, 18 Nov 2017 02:23:35 GMT

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