<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic tMatchgroup -- missing some matches in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364434#M128177</link>
    <description>&lt;P&gt;&lt;SPAN&gt;I see an issue with Talend Match component while doing the matching between the records. &lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Match Rules:&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;===========&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;1. Match on same&amp;nbsp;Party_Nm and Addr_1.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;2. Match on same Ident_Type and Ident_Val&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Below is one simple example. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I am taking 2&amp;nbsp;party records. Party 1 is having two identifiers IMS and DDD. Party 1 and 2 have same DDD identifier. When we send this data set to match component Talend treats the first record as Mater record and all other records will try to get matched against this record. In this case the two Party 1 records are getting matched (self-matching) as they have same name and address. But Party 1 and 2 are not getting matched even though the ident_type and Ident_val are same.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Ideally we expect Party 1 and 2 should get matched. &amp;nbsp;Has anyone come across this scenario? Please let me know.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Input data&lt;/P&gt; 
&lt;P&gt;========&lt;BR /&gt;&lt;SPAN&gt;Party_Key|Party_Nm|Addr_1|State|Ident_Type|Ident_Val &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1| aaaaaaaaaa|123 Main St| NJ |IMS|12334556 (Master Record) &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1| aaaaaaaaaa| 123 Main St| NJ |DDD|45678909 &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2| cccccccccccc| 111 Temp St| NJ |DDD|45678909&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Match Results &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;=========== &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1 &amp;nbsp; 1 Matches &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2 &amp;nbsp; &amp;nbsp; &amp;nbsp;Unique &lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 20 Jul 2018 15:55:01 GMT</pubDate>
    <dc:creator>skishore79</dc:creator>
    <dc:date>2018-07-20T15:55:01Z</dc:date>
    <item>
      <title>tMatchgroup -- missing some matches</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364434#M128177</link>
      <description>&lt;P&gt;&lt;SPAN&gt;I see an issue with Talend Match component while doing the matching between the records. &lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Match Rules:&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;===========&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;1. Match on same&amp;nbsp;Party_Nm and Addr_1.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;2. Match on same Ident_Type and Ident_Val&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Below is one simple example. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I am taking 2&amp;nbsp;party records. Party 1 is having two identifiers IMS and DDD. Party 1 and 2 have same DDD identifier. When we send this data set to match component Talend treats the first record as Mater record and all other records will try to get matched against this record. In this case the two Party 1 records are getting matched (self-matching) as they have same name and address. But Party 1 and 2 are not getting matched even though the ident_type and Ident_val are same.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Ideally we expect Party 1 and 2 should get matched. &amp;nbsp;Has anyone come across this scenario? Please let me know.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Input data&lt;/P&gt; 
&lt;P&gt;========&lt;BR /&gt;&lt;SPAN&gt;Party_Key|Party_Nm|Addr_1|State|Ident_Type|Ident_Val &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1| aaaaaaaaaa|123 Main St| NJ |IMS|12334556 (Master Record) &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1| aaaaaaaaaa| 123 Main St| NJ |DDD|45678909 &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2| cccccccccccc| 111 Temp St| NJ |DDD|45678909&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Match Results &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;=========== &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1 &amp;nbsp; 1 Matches &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2 &amp;nbsp; &amp;nbsp; &amp;nbsp;Unique &lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 20 Jul 2018 15:55:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364434#M128177</guid>
      <dc:creator>skishore79</dc:creator>
      <dc:date>2018-07-20T15:55:01Z</dc:date>
    </item>
    <item>
      <title>Re: tMatchgroup -- missing some matches</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364435#M128178</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; I tried your sample set of 3 records and was able to create matches based on both of your rules.&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; Please see the result set below.&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 400px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzLU.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/149732i79CDEF24C9944E62/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LzLU.png" alt="0683p000009LzLU.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;In the tmatchgroup component, you need to create configurations for both match rules.&lt;/P&gt; 
&lt;P&gt;Match rule 1:-&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 400px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzLZ.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/150872i430B2A69A4737E04/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LzLZ.png" alt="0683p000009LzLZ.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Match rule 2:-&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 400px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzLe.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/150656iB0AA56BBD1272162/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LzLe.png" alt="0683p000009LzLe.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Also, have a close watch on the advanced settings of tmatchgroup and I would also suggest you to go through the scenarios mentioned in help document.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I have attached the pseudo code as zip file for your easy reference. If the suggestion given has resolved your query, please mark the topic as accepted solution received.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Warm Regards,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Nikhil Thampi&lt;/P&gt;&lt;BR /&gt;&lt;A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009LtIe"&gt;test3.zip&lt;/A&gt;</description>
      <pubDate>Sat, 21 Jul 2018 20:37:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364435#M128178</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-07-21T20:37:24Z</dc:date>
    </item>
    <item>
      <title>Re: tMatchgroup -- missing some matches</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364436#M128179</link>
      <description>&lt;P&gt;Hi Nikhil,&lt;/P&gt;&lt;P&gt;Thanks for your reply. I am expecting Party 1 and 2 should get matched but in the result screenshot that you sent shows that all 3 records have different Group ID. GID will&amp;nbsp;be same if they got matched. It seems nothing got matched.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Kishore&lt;/P&gt;</description>
      <pubDate>Wed, 25 Jul 2018 15:27:57 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364436#M128179</guid>
      <dc:creator>skishore79</dc:creator>
      <dc:date>2018-07-25T15:27:57Z</dc:date>
    </item>
    <item>
      <title>Re: tMatchgroup -- missing some matches</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364437#M128180</link>
      <description>&lt;P&gt;Hi Kishore,&lt;/P&gt;&lt;P&gt;I am having same issue. matches which i am expecting to go into Matches are going into Uniques. were you able to resolve your issue? please help.&lt;/P&gt;</description>
      <pubDate>Sat, 11 Aug 2018 00:01:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tMatchgroup-missing-some-matches/m-p/2364437#M128180</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-08-11T00:01:13Z</dc:date>
    </item>
  </channel>
</rss>

