Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

left join.docx

Not applicable

left join.docx

hi  i faced this problem can any one explain?

Attachments
Comments
qv_testing
Valued Contributor

HI,

Exactly what you want??

use right join,

otherwise, first  you can load vegetables after that fruits........

Hi Madhu,

Post this question in proper thread to get answer like in New to qlikview or New to Qlik Sense, You post the document here.

Regards

Anand

qv_testing
Valued Contributor

Hi Madhu,

Post in Discussion and in Document

nicolas66
New Contributor III

Hi,

left join (Fruits)

load vegetables:

BR,

Not applicable

Hi,

I think may be in this way.

Fruits:

LOAD * Inline [

Fruits, Colour

Mango, Green

Promogranate, Red

Oranges, Yellow ];

Left Join(Fruits)

Vegitables:

Load * Inline [

Vegitables, Colour

Chilli, Green

Lemon, Yellow

Radish, White ];

Not applicable

Hi Madhu,

Please try this.

Left Join :- First load Main Table and then second, as below mentioned....

Vegetables:

LOAD * INLINE [

    Vegetables, Colour

    Chilli, Green

    Lemon , Yellow

    Radish , White ];

  

Left Join(Vegetables)

  

Fruits:

LOAD * INLINE [

    Fruits, Colour

    Mango, Green

    Pomogranate, Red

    Oragens, Yellow

];

Regards,

Sub2u

Version history
Revision #:
1 of 1
Last update:
‎11-28-2014 01:58 AM
Updated by: