<?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 Error Extracting Data From Oracle in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Error-Extracting-Data-From-Oracle/m-p/58248#M9705</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Community,&lt;/P&gt;&lt;P&gt;I'm having a rear problem when i'm extracting data from oracle database,&amp;nbsp; I don't know if somebody can help me.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Query Extract Using Oracle Developer&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193975_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The Same Query Using Qlikview&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193976_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As you can see on oracle for num_certificado=103614 I have the num_siniestro=7207-10-00001 but the result on Qlik is 7207-09-00031. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I extract only one row when the num_certificado=103614 Qlik extract the correct data. Is realy rear, I never see this issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the version used is:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/193977_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;thanks for your help!!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 20 Feb 2018 21:30:44 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-02-20T21:30:44Z</dc:date>
    <item>
      <title>Error Extracting Data From Oracle</title>
      <link>https://community.qlik.com/t5/QlikView/Error-Extracting-Data-From-Oracle/m-p/58248#M9705</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Community,&lt;/P&gt;&lt;P&gt;I'm having a rear problem when i'm extracting data from oracle database,&amp;nbsp; I don't know if somebody can help me.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Query Extract Using Oracle Developer&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193975_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The Same Query Using Qlikview&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193976_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As you can see on oracle for num_certificado=103614 I have the num_siniestro=7207-10-00001 but the result on Qlik is 7207-09-00031. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I extract only one row when the num_certificado=103614 Qlik extract the correct data. Is realy rear, I never see this issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the version used is:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/193977_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;thanks for your help!!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 20 Feb 2018 21:30:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Error-Extracting-Data-From-Oracle/m-p/58248#M9705</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-02-20T21:30:44Z</dc:date>
    </item>
  </channel>
</rss>

