<?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 convert the below Teradata script into Qlik script. in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524809#M106949</link>
    <description>&lt;DIV class=""&gt;Convert the below tera data Query into the Qlik Script.&lt;/DIV&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;CREATE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;VOLATILE MULTISET&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;TABLE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;funnel&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;AS&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(&lt;/DIV&gt;&lt;DIV class=""&gt;SELECT&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;*&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;FROM&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;dev_bpl.funnel&lt;/DIV&gt;&lt;DIV class=""&gt;QUALIFY ROW_NUMBER() OVER (PARTITION&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;BY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Event_Id&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ORDER&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;BY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;TD_SYSFNLIB.NVL (order_id, 0)&amp;nbsp;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;DESC) = 1&lt;/DIV&gt;&lt;DIV class=""&gt;)&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;WITH&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;DATA&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;PRIMARY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;INDEX&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(Event_Id)&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ON&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;COMMIT&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;PRESERVE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ROWS;&lt;/DIV&gt;</description>
    <pubDate>Mon, 21 Jul 2025 11:14:26 GMT</pubDate>
    <dc:creator>Qlikbuddy</dc:creator>
    <dc:date>2025-07-21T11:14:26Z</dc:date>
    <item>
      <title>convert the below Teradata script into Qlik script.</title>
      <link>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524809#M106949</link>
      <description>&lt;DIV class=""&gt;Convert the below tera data Query into the Qlik Script.&lt;/DIV&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;CREATE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;VOLATILE MULTISET&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;TABLE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;funnel&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;AS&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(&lt;/DIV&gt;&lt;DIV class=""&gt;SELECT&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;*&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;FROM&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;dev_bpl.funnel&lt;/DIV&gt;&lt;DIV class=""&gt;QUALIFY ROW_NUMBER() OVER (PARTITION&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;BY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Event_Id&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ORDER&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;BY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;TD_SYSFNLIB.NVL (order_id, 0)&amp;nbsp;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;DESC) = 1&lt;/DIV&gt;&lt;DIV class=""&gt;)&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;WITH&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;DATA&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;PRIMARY&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;INDEX&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(Event_Id)&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ON&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;COMMIT&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;PRESERVE&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ROWS;&lt;/DIV&gt;</description>
      <pubDate>Mon, 21 Jul 2025 11:14:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524809#M106949</guid>
      <dc:creator>Qlikbuddy</dc:creator>
      <dc:date>2025-07-21T11:14:26Z</dc:date>
    </item>
    <item>
      <title>Re: convert the below Teradata script into Qlik script.</title>
      <link>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524811#M106950</link>
      <description>&lt;P&gt;you may try using Autonumber or comparing Id with previous Id.&lt;/P&gt;&lt;P&gt;use below links for reference.&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/t5/QlikView-App-Dev/ROW-NUMBER-OVER-PARTITION-BY-A-B-C-ordered-by-x/td-p/123009" target="_blank"&gt;https://community.qlik.com/t5/QlikView-App-Dev/ROW-NUMBER-OVER-PARTITION-BY-A-B-C-ordered-by-x/td-p/123009&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/t5/App-Development/Row-number-over-partition-by/td-p/2112712" target="_blank"&gt;https://community.qlik.com/t5/App-Development/Row-number-over-partition-by/td-p/2112712&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/t5/Visualization-and-Usability/SQL-ROW-NUMBER-OVER-PARTITION-BY-ORDER-BY-Row-Number-in-Qlik/td-p/2140322" target="_blank"&gt;https://community.qlik.com/t5/Visualization-and-Usability/SQL-ROW-NUMBER-OVER-PARTITION-BY-ORDER-BY-Row-Number-in-Qlik/td-p/2140322&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 21 Jul 2025 12:03:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524811#M106950</guid>
      <dc:creator>anat</dc:creator>
      <dc:date>2025-07-21T12:03:42Z</dc:date>
    </item>
    <item>
      <title>Re: convert the below Teradata script into Qlik script.</title>
      <link>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524901#M106954</link>
      <description>&lt;P&gt;Would be great, if some one convert it for me in entire Qlik script. some how i am not able to convert it.&lt;/P&gt;</description>
      <pubDate>Tue, 22 Jul 2025 09:07:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/convert-the-below-Teradata-script-into-Qlik-script/m-p/2524901#M106954</guid>
      <dc:creator>Qlikbuddy</dc:creator>
      <dc:date>2025-07-22T09:07:37Z</dc:date>
    </item>
  </channel>
</rss>

