<?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 SQL Query of Analysis Result in Data Quality</title>
    <link>https://community.qlik.com/t5/Data-Quality/SQL-Query-of-Analysis-Result/m-p/2266515#M2171</link>
    <description>&lt;P&gt;Hi, I m using Talend data quality tool for profiling. I need to extract sql query generated during data analysis for e.x. -&amp;nbsp; the analysis on some particular table says&amp;nbsp;there are 10 rows with null asset_id and when I right click to see those ten records,it shown those&amp;nbsp; records and a query which generate those 10 records. I want to extract that query, can anybody suggest how to do that.Below screenshot shows the sql query i need to extract. Will appreciate the quick response as I need to work on it.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks&lt;/P&gt; 
&lt;P&gt;Aanchal&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot of sql query i need to extract.PNG" style="width: 678px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1Hk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/157821iB22C657EFABEC48F/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M1Hk.png" alt="0683p000009M1Hk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 07:08:29 GMT</pubDate>
    <dc:creator>aanchal_s</dc:creator>
    <dc:date>2024-11-16T07:08:29Z</dc:date>
    <item>
      <title>SQL Query of Analysis Result</title>
      <link>https://community.qlik.com/t5/Data-Quality/SQL-Query-of-Analysis-Result/m-p/2266515#M2171</link>
      <description>&lt;P&gt;Hi, I m using Talend data quality tool for profiling. I need to extract sql query generated during data analysis for e.x. -&amp;nbsp; the analysis on some particular table says&amp;nbsp;there are 10 rows with null asset_id and when I right click to see those ten records,it shown those&amp;nbsp; records and a query which generate those 10 records. I want to extract that query, can anybody suggest how to do that.Below screenshot shows the sql query i need to extract. Will appreciate the quick response as I need to work on it.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks&lt;/P&gt; 
&lt;P&gt;Aanchal&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot of sql query i need to extract.PNG" style="width: 678px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1Hk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/157821iB22C657EFABEC48F/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M1Hk.png" alt="0683p000009M1Hk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 07:08:29 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Data-Quality/SQL-Query-of-Analysis-Result/m-p/2266515#M2171</guid>
      <dc:creator>aanchal_s</dc:creator>
      <dc:date>2024-11-16T07:08:29Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Query of Analysis Result</title>
      <link>https://community.qlik.com/t5/Data-Quality/SQL-Query-of-Analysis-Result/m-p/2266516#M2172</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P class="p" style="background-color: transparent; box-sizing: border-box; color: #444444; font-family: &amp;amp;quot; source sans pro&amp;amp;quot;,sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-top: 15.33px; max-width: 1533.33px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;In the SQL editor, click the save icon on the toolbar to save the executed query on the SQL business rule and list it under the &lt;SPAN class="ph uicontrol" style="box-sizing: border-box; font-weight: bold; -webkit-tap-highlight-color: transparent;"&gt;Libraries &amp;gt; Source Files&lt;/SPAN&gt; folder in the &lt;SPAN class="ph uicontrol" style="box-sizing: border-box; font-weight: bold; -webkit-tap-highlight-color: transparent;"&gt;DQ Repository&lt;/SPAN&gt; tree view.&lt;/P&gt;
&lt;P class="p" style="background-color: transparent; box-sizing: border-box; color: #444444; font-family: &amp;amp;quot; source sans pro&amp;amp;quot;,sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-top: 15.33px; max-width: 1533.33px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;For further information, see &lt;A class="xref ft-internal-link" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; box-sizing: border-box; color: #0675c1; -webkit-tap-highlight-color: transparent;" href="https://help.talend.com/reader/JBd55tmCE93A7EfF24e2KA/cOQsj24nTWijYXmF23_38Q" target="_blank" rel="nofollow noopener noreferrer"&gt;Saving the queries executed on indicators&lt;/A&gt;.&lt;/P&gt;
&lt;P class="p" style="background-color: transparent; box-sizing: border-box; color: #444444; font-family: &amp;amp;quot; source sans pro&amp;amp;quot;,sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-top: 15.33px; max-width: 1533.33px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;Best regards&lt;/P&gt;
&lt;P class="p" style="background-color: transparent; box-sizing: border-box; color: #444444; font-family: &amp;amp;quot; source sans pro&amp;amp;quot;,sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-top: 15.33px; max-width: 1533.33px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;Sabrina&lt;/P&gt;</description>
      <pubDate>Wed, 23 Jan 2019 08:57:02 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Data-Quality/SQL-Query-of-Analysis-Result/m-p/2266516#M2172</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-23T08:57:02Z</dc:date>
    </item>
  </channel>
</rss>

