<?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 Re: Merge the data in a file in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308425#M79757</link>
    <description>&lt;P&gt;Hey vidya,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1.) good description have your challange, helps other to help you.&lt;/P&gt;
&lt;P&gt;2.)If you started the conversation elsewhere and start of here ... not a good practise&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Your sample text does not merge the data. The output clearly shows you do filter based on content.&lt;/P&gt;
&lt;PRE&gt;Input
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1grGy
entree dans camm_prem_scheduler , Para|79349|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1iH68
entree dans camm_prem_scheduler , Para|79315|79321|-1
entree dans camm_prem_scheduler , Para|79343|79321|-1
entree dans camm_prem_scheduler , Para|79374|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$tQF1
entree dans camm_prem_scheduler , Para|79373|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$wYTv
entree dans camm_prem_scheduler , Para|79358|79321|-1

Output
$bllngdtl:cp_billing_dtl$1grGy|79349
$bllngdtl:cp_billing_dtl$1iH68|79315
$bllngdtl:cp_billing_dtl$1iH68|79343
$bllngdtl:cp_billing_dtl$1iH68|79374
$bllngdtl:cp_billing_dtl$tQF1|79373
$bllngdtl:cp_billing_dtl$wYTv|79358&lt;/PRE&gt;
&lt;P&gt;... Solution : Use a filter in a tmap or a tfilterrow&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;BR Bp&lt;/P&gt;</description>
    <pubDate>Fri, 09 Mar 2018 11:35:35 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-03-09T11:35:35Z</dc:date>
    <item>
      <title>Merge the data in a file</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308424#M79756</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Could you please suggest appropriate solution for the issue attached.&lt;/P&gt;
&lt;P&gt;&lt;A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG"&gt;@TRF&lt;/A&gt; has mentioned that there is a simplest approach to restore the alternation.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Fri, 09 Mar 2018 09:46:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308424#M79756</guid>
      <dc:creator>vidya821</dc:creator>
      <dc:date>2018-03-09T09:46:16Z</dc:date>
    </item>
    <item>
      <title>Re: Merge the data in a file</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308425#M79757</link>
      <description>&lt;P&gt;Hey vidya,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1.) good description have your challange, helps other to help you.&lt;/P&gt;
&lt;P&gt;2.)If you started the conversation elsewhere and start of here ... not a good practise&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Your sample text does not merge the data. The output clearly shows you do filter based on content.&lt;/P&gt;
&lt;PRE&gt;Input
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1grGy
entree dans camm_prem_scheduler , Para|79349|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1iH68
entree dans camm_prem_scheduler , Para|79315|79321|-1
entree dans camm_prem_scheduler , Para|79343|79321|-1
entree dans camm_prem_scheduler , Para|79374|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$tQF1
entree dans camm_prem_scheduler , Para|79373|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$wYTv
entree dans camm_prem_scheduler , Para|79358|79321|-1

Output
$bllngdtl:cp_billing_dtl$1grGy|79349
$bllngdtl:cp_billing_dtl$1iH68|79315
$bllngdtl:cp_billing_dtl$1iH68|79343
$bllngdtl:cp_billing_dtl$1iH68|79374
$bllngdtl:cp_billing_dtl$tQF1|79373
$bllngdtl:cp_billing_dtl$wYTv|79358&lt;/PRE&gt;
&lt;P&gt;... Solution : Use a filter in a tmap or a tfilterrow&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;BR Bp&lt;/P&gt;</description>
      <pubDate>Fri, 09 Mar 2018 11:35:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308425#M79757</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-03-09T11:35:35Z</dc:date>
    </item>
    <item>
      <title>Re: Merge the data in a file</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308426#M79758</link>
      <description>&lt;P&gt;Thanks Bellis...&lt;/P&gt;
&lt;P&gt;My Apologies, i was actually suggested to raise a&amp;nbsp;new topic..:-)&lt;/P&gt;
&lt;P&gt;Yes,&amp;nbsp;I have found the solution based on the content...&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 12 Mar 2018 08:15:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Merge-the-data-in-a-file/m-p/2308426#M79758</guid>
      <dc:creator>vidya821</dc:creator>
      <dc:date>2018-03-12T08:15:55Z</dc:date>
    </item>
  </channel>
</rss>

