topic Re: Right/Left Join with exclusion in QlikView https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98914#M15820 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15376372052762408 jive_text_macro" jivemacro_uid="_15376372052762408" modifiedtitle="true"> <P></P> <P></P> <P>Matched_Cat:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product, Category</P> <P>&nbsp;&nbsp;&nbsp; Name3, Category2</P> <P>&nbsp;&nbsp;&nbsp; Name4, Category3</P> <P>&nbsp;&nbsp;&nbsp; Name5, Category4</P> <P>&nbsp;&nbsp;&nbsp; Name6, Category6</P> <P>];</P> <P></P> <P></P> <P>ProdData:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product</P> <P>&nbsp;&nbsp;&nbsp; Name1</P> <P>&nbsp;&nbsp;&nbsp; Name2</P> <P>&nbsp;&nbsp;&nbsp; Name3</P> <P>&nbsp;&nbsp;&nbsp; Name4</P> <P>&nbsp;&nbsp;&nbsp; Name5</P> <P>&nbsp;&nbsp;&nbsp; Name6</P> <P>&nbsp;&nbsp;&nbsp; Name7</P> <P>]</P> <P>Where NOT Exists(Product)</P> <P>;</P> </PRE><P></P><P></P><P>May be this.?</P></BODY></HTML> Sat, 22 Sep 2018 17:27:15 GMT nsetty 2018-09-22T17:27:15Z Right/Left Join with exclusion https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98912#M15818 <HTML><HEAD></HEAD><BODY><P>Hi, All</P><P></P><P>Can somebody help to do Right/Left&nbsp; Join with exclusion.</P><P><IMG alt="VennDiagram1.pdf - Google Chrome 2018-09-22 16.48.41.png" class="jive-image image-1" src="/legacyfs/online/214195_VennDiagram1.pdf - Google Chrome 2018-09-22 16.48.41.png" style="height: 108px; width: 620px;" /></P><P>My case - I have to tables:</P><P></P><P><SPAN style="font-size: 13.3333px;">Matched_Cat:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Product, Category</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name3, Category2</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name4, Category3</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name5, Category4</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name6, Category6</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Data:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Product</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name1</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name2</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name3</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name4</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name5</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name6</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name7</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P><P></P><P></P><P>Expected Result:</P><P></P><P>exclusion:</P><P>&nbsp;&nbsp;&nbsp; Product</P><P>&nbsp;&nbsp;&nbsp; Name1</P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name7</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Many thanks<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Sat, 22 Sep 2018 13:53:38 GMT https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98912#M15818 vadim_grab 2018-09-22T13:53:38Z Re: Right/Left Join with exclusion https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98913#M15819 <HTML><HEAD></HEAD><BODY><P>Maybe like this:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15376249366956507 jive_text_macro" jivemacro_uid="_15376249366956507" modifiedtitle="true"> <P>Matched_Cat:</P> <P>Mapping LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product, Category</P> <P>&nbsp;&nbsp;&nbsp; Name3, Category2</P> <P>&nbsp;&nbsp;&nbsp; Name4, Category3</P> <P>&nbsp;&nbsp;&nbsp; Name5, Category4</P> <P>&nbsp;&nbsp;&nbsp; Name6, Category6</P> <P>];</P> <P></P> <P></P> <P>Data:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product</P> <P>&nbsp;&nbsp;&nbsp; Name1</P> <P>&nbsp;&nbsp;&nbsp; Name2</P> <P>&nbsp;&nbsp;&nbsp; Name3</P> <P>&nbsp;&nbsp;&nbsp; Name4</P> <P>&nbsp;&nbsp;&nbsp; Name5</P> <P>&nbsp;&nbsp;&nbsp; Name6</P> <P>&nbsp;&nbsp;&nbsp; Name7</P> <P>] where&nbsp; If(ApplyMap('Matched_Cat',Product,'#na')='#na',1,0)=1;</P> <P></P> <P></P> </PRE></BODY></HTML> Sat, 22 Sep 2018 14:03:57 GMT https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98913#M15819 Frank_Hartmann 2018-09-22T14:03:57Z Re: Right/Left Join with exclusion https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98914#M15820 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15376372052762408 jive_text_macro" jivemacro_uid="_15376372052762408" modifiedtitle="true"> <P></P> <P></P> <P>Matched_Cat:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product, Category</P> <P>&nbsp;&nbsp;&nbsp; Name3, Category2</P> <P>&nbsp;&nbsp;&nbsp; Name4, Category3</P> <P>&nbsp;&nbsp;&nbsp; Name5, Category4</P> <P>&nbsp;&nbsp;&nbsp; Name6, Category6</P> <P>];</P> <P></P> <P></P> <P>ProdData:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Product</P> <P>&nbsp;&nbsp;&nbsp; Name1</P> <P>&nbsp;&nbsp;&nbsp; Name2</P> <P>&nbsp;&nbsp;&nbsp; Name3</P> <P>&nbsp;&nbsp;&nbsp; Name4</P> <P>&nbsp;&nbsp;&nbsp; Name5</P> <P>&nbsp;&nbsp;&nbsp; Name6</P> <P>&nbsp;&nbsp;&nbsp; Name7</P> <P>]</P> <P>Where NOT Exists(Product)</P> <P>;</P> </PRE><P></P><P></P><P>May be this.?</P></BODY></HTML> Sat, 22 Sep 2018 17:27:15 GMT https://community.qlik.com/t5/QlikView/Right-Left-Join-with-exclusion/m-p/98914#M15820 nsetty 2018-09-22T17:27:15Z