topic Re: Join problem in QlikView

Join problem

Mon, 18 Feb 2013 13:02:56 GMT

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.

Re: Join problem

martin59 — Mon, 18 Feb 2013 13:12:49 GMT

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

martin59 — Mon, 18 Feb 2013 13:12:57 GMT

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

martin59 — Mon, 18 Feb 2013 13:13:02 GMT

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

alexandros17 — Mon, 18 Feb 2013 13:18:37 GMT

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

Re: Join problem

jagan — Mon, 18 Feb 2013 15:34:45 GMT

Hi,

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

Regards,

Jagan.