<?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 Performance for Qlik Analytical connection in load editor in Integration, Extension &amp; APIs</title>
    <link>https://community.qlik.com/t5/Integration-Extension-APIs/Performance-for-Qlik-Analytical-connection-in-load-editor/m-p/2109277#M19063</link>
    <description>&lt;P&gt;Dear Community,&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Trying to use the aes capabilities in form analytical connection (AC) as published on git hub:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://github.com/Qlik-PE/javaSSE" target="_blank"&gt;https://github.com/Qlik-PE/javaSSE&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;Data Load Editor script is attached :&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;[DateFlieSeed100.csv_pii_masked]:&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;LOAD&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ID],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [NAME],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [DOB],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ACCOUNT]&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp;FROM [lib://QlikSetup/DateFlieSeed100.csv_pii_masked.csv]&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;(txt, utf8, embedded labels, delimiter is ',', msq);&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;Load&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ID],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; DataPlus.UnMaskData([NAME],'NAME') as unmasked_name,&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp; &amp;nbsp; DataPlus.UnMaskData([DOB],'DOB') as unmasked_dob,&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp; &amp;nbsp; DataPlus.UnMaskData([ACCOUNT],'ACCOUNT') as unmasked_account;&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;P&gt;While checking logs, I am finding that in execute function, bundledrow is having single column value, and execute function is called for every column values in my file against each column above for which we used AC.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;My question here is:&lt;/P&gt;
&lt;P&gt;For any analytical connection used this way, is it possible that execute function gets multiple column values in one call&amp;nbsp;&amp;nbsp;instead one by one? How can we achieve it in load editor? Or is there any configuration which needs to be set?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Looking forward to your kind replies....&lt;/P&gt;</description>
    <pubDate>Thu, 24 Aug 2023 06:54:44 GMT</pubDate>
    <dc:creator>hemantjoshi</dc:creator>
    <dc:date>2023-08-24T06:54:44Z</dc:date>
    <item>
      <title>Performance for Qlik Analytical connection in load editor</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/Performance-for-Qlik-Analytical-connection-in-load-editor/m-p/2109277#M19063</link>
      <description>&lt;P&gt;Dear Community,&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Trying to use the aes capabilities in form analytical connection (AC) as published on git hub:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://github.com/Qlik-PE/javaSSE" target="_blank"&gt;https://github.com/Qlik-PE/javaSSE&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;Data Load Editor script is attached :&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;[DateFlieSeed100.csv_pii_masked]:&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;LOAD&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ID],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [NAME],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [DOB],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ACCOUNT]&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp;FROM [lib://QlikSetup/DateFlieSeed100.csv_pii_masked.csv]&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;(txt, utf8, embedded labels, delimiter is ',', msq);&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;Load&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; [ID],&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt; DataPlus.UnMaskData([NAME],'NAME') as unmasked_name,&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp; &amp;nbsp; DataPlus.UnMaskData([DOB],'DOB') as unmasked_dob,&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&lt;EM&gt;&amp;nbsp; &amp;nbsp; DataPlus.UnMaskData([ACCOUNT],'ACCOUNT') as unmasked_account;&lt;/EM&gt;&lt;/DIV&gt;
&lt;DIV class="lia-align-left"&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;P&gt;While checking logs, I am finding that in execute function, bundledrow is having single column value, and execute function is called for every column values in my file against each column above for which we used AC.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;My question here is:&lt;/P&gt;
&lt;P&gt;For any analytical connection used this way, is it possible that execute function gets multiple column values in one call&amp;nbsp;&amp;nbsp;instead one by one? How can we achieve it in load editor? Or is there any configuration which needs to be set?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Looking forward to your kind replies....&lt;/P&gt;</description>
      <pubDate>Thu, 24 Aug 2023 06:54:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/Performance-for-Qlik-Analytical-connection-in-load-editor/m-p/2109277#M19063</guid>
      <dc:creator>hemantjoshi</dc:creator>
      <dc:date>2023-08-24T06:54:44Z</dc:date>
    </item>
  </channel>
</rss>

