Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Join problem

Hi,

      I have a Join problem in my application from attached file join is created between g, j, and mapping table but i want a direct join  so please help me on this.

5 Replies
martin59
Valued Contributor II

Re: Join problem

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

martin59
Valued Contributor II

Re: Join problem

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

martin59
Valued Contributor II

Re: Join problem

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

Re: Join problem

If you want to keep separate the G and J tables you can :  table G left join Mapping tables and left J table linking with the result.

If you want an unique table :

Mapping

left join

G

left join

J

MVP
MVP

Re: Join problem

Hi,

You data seems to have no common values between the two tables.

Regards,

Jagan.

Community Browser