correction needed in the attached app

[bhavvibudagam]

Hi Experts,

Can any one please help me on below scenario.

I have 4 input files.

Config File is the Main Table.

PG,Capabily and Coverage are the Subtables.

• In between Config and PG the common Field is PG.Based on PG need to do left join.
• In between Config and Capability common Field is Capability.Based on Capability need to do left join.
• In between Config and Coverage common Field is Coverage.Based on Coverage need to do left join.

Here only first left join is working. please help me on this.

when PG is not null then PG hours comes under Hours field.

When PG and Capability is null then Hours related to Coverage comes under Hours field.

When PG and Coverage is null then Hours related to Capability comes under Hours field.

Thanks in advance,

[#2]

Dear Bhavani,

Please find the attachment for required output.

Thanks & Regards,

Neha Malekar

[jonathandienst · Accepted solution]

Why join the tables? You can let QV associations do all the work for you.

You will need to rename the hours fields to prevent them being associated. you could do this by using Qualify Hours before loading the tables.. Then you will get 4 tables associated by PG, Capability and Coverage. Your expression could then be

    =Alt(PG.Hours, Capability.Hours, Coverage.Hours)

[Anil_Babu_Samineni]

Don't dump for single solution Re: Left join Help