<?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 How to get total row count from input tmap row in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-get-total-row-count-from-input-tmap-row/m-p/2221289#M15358</link>
    <description>&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am calculating percentage of total for a specific column. With a tAggregateRow, I grouped based on a column (Account_Status). Now I need to calculate the percentage of each status out of total. So, I am using tMap after my&amp;nbsp;tAggregateRow. I created a new column (Account%) in my output.&amp;nbsp;&lt;/P&gt;&lt;P&gt;I need to execute:&lt;/P&gt;&lt;P&gt;(total of Account_Status/total input row count)*100&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How can i get total row count of my input row of the tmap? Please help&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 03:08:15 GMT</pubDate>
    <dc:creator>dattasud</dc:creator>
    <dc:date>2024-11-16T03:08:15Z</dc:date>
    <item>
      <title>How to get total row count from input tmap row</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-get-total-row-count-from-input-tmap-row/m-p/2221289#M15358</link>
      <description>&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am calculating percentage of total for a specific column. With a tAggregateRow, I grouped based on a column (Account_Status). Now I need to calculate the percentage of each status out of total. So, I am using tMap after my&amp;nbsp;tAggregateRow. I created a new column (Account%) in my output.&amp;nbsp;&lt;/P&gt;&lt;P&gt;I need to execute:&lt;/P&gt;&lt;P&gt;(total of Account_Status/total input row count)*100&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How can i get total row count of my input row of the tmap? Please help&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 03:08:15 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-get-total-row-count-from-input-tmap-row/m-p/2221289#M15358</guid>
      <dc:creator>dattasud</dc:creator>
      <dc:date>2024-11-16T03:08:15Z</dc:date>
    </item>
    <item>
      <title>Re: How to get total row count from input tmap row</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-get-total-row-count-from-input-tmap-row/m-p/2221290#M15359</link>
      <description>I got the row count using global map variable :&lt;BR /&gt;(Integer) globalMap.get("tSalesforceInput_2_NB_LINE"))&lt;BR /&gt;&lt;BR /&gt;Thanks.</description>
      <pubDate>Fri, 28 Feb 2020 21:26:02 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-get-total-row-count-from-input-tmap-row/m-p/2221290#M15359</guid>
      <dc:creator>dattasud</dc:creator>
      <dc:date>2020-02-28T21:26:02Z</dc:date>
    </item>
  </channel>
</rss>

