<?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 Incremental load using Component Keys in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Incremental-load-using-Component-Keys/m-p/672121#M244117</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to figure out how to set up my incremental load scrip &lt;STRONG style="text-decoration: underline;"&gt;without a unique ID-field in my source data&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;In other words I need to create Component Keys of some kind to be able to identify/replace rows in my QVD file.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Pls find attached to see which approach I've been trying to utilize.&lt;/P&gt;&lt;P&gt;I bet it works great, however I cannot seem to come around the unique ID-issue. &lt;/P&gt;&lt;P&gt;When trying to LOAD a component key, lets's say &lt;SPAN style="color: #ff0000;"&gt;x&lt;/SPAN&gt;&amp;amp;&lt;SPAN style="color: #ff0000;"&gt;y&lt;/SPAN&gt;&amp;amp;&lt;SPAN style="color: #ff0000;"&gt;q&lt;/SPAN&gt; &lt;SPAN style="color: #3366ff;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;UniqueKey &lt;SPAN style="color: #666699;"&gt;the Incremental Load part cannot find the field. I tried doing a preceeding load too,without any luck. &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Any ideas?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Thanks in advance,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Olle &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 23 Sep 2014 12:24:43 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-09-23T12:24:43Z</dc:date>
    <item>
      <title>Incremental load using Component Keys</title>
      <link>https://community.qlik.com/t5/QlikView/Incremental-load-using-Component-Keys/m-p/672121#M244117</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to figure out how to set up my incremental load scrip &lt;STRONG style="text-decoration: underline;"&gt;without a unique ID-field in my source data&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;In other words I need to create Component Keys of some kind to be able to identify/replace rows in my QVD file.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Pls find attached to see which approach I've been trying to utilize.&lt;/P&gt;&lt;P&gt;I bet it works great, however I cannot seem to come around the unique ID-issue. &lt;/P&gt;&lt;P&gt;When trying to LOAD a component key, lets's say &lt;SPAN style="color: #ff0000;"&gt;x&lt;/SPAN&gt;&amp;amp;&lt;SPAN style="color: #ff0000;"&gt;y&lt;/SPAN&gt;&amp;amp;&lt;SPAN style="color: #ff0000;"&gt;q&lt;/SPAN&gt; &lt;SPAN style="color: #3366ff;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;UniqueKey &lt;SPAN style="color: #666699;"&gt;the Incremental Load part cannot find the field. I tried doing a preceeding load too,without any luck. &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Any ideas?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Thanks in advance,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;Olle &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 23 Sep 2014 12:24:43 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Incremental-load-using-Component-Keys/m-p/672121#M244117</guid>
      <dc:creator />
      <dc:date>2014-09-23T12:24:43Z</dc:date>
    </item>
  </channel>
</rss>

