<?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 Skip exception on tMysqlInput component in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Skip-exception-on-tMysqlInput-component/m-p/2286353#M59975</link>
    <description>I am trying to skip the exception on tMysqlInput component. My Query is simple like 
&lt;BR /&gt;"SELECT "+row10.sid+" ,"+row10.qid+" ,"+row10.parent_qid+" ,"+row10.gid+" , 
&lt;BR /&gt;"+row10.survey_table+"."+row10.survey_title+" as response,id as response_id 
&lt;BR /&gt;FROM "+row10.survey_table 
&lt;BR /&gt;Here row10.survey_table is a dynamic which depends on sid, it may exists to some or may not to some ID's. 
&lt;BR /&gt;My intention is to skip the exception when row10.table_1 is not existing. 
&lt;BR /&gt;Please find my Job 
&lt;BR /&gt; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBcm.jpg"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/140875iB9F536F05DD88404/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MBcm.jpg" alt="0683p000009MBcm.jpg" /&gt;&lt;/span&gt;</description>
    <pubDate>Mon, 04 Nov 2013 13:57:42 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2013-11-04T13:57:42Z</dc:date>
    <item>
      <title>Skip exception on tMysqlInput component</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Skip-exception-on-tMysqlInput-component/m-p/2286353#M59975</link>
      <description>I am trying to skip the exception on tMysqlInput component. My Query is simple like 
&lt;BR /&gt;"SELECT "+row10.sid+" ,"+row10.qid+" ,"+row10.parent_qid+" ,"+row10.gid+" , 
&lt;BR /&gt;"+row10.survey_table+"."+row10.survey_title+" as response,id as response_id 
&lt;BR /&gt;FROM "+row10.survey_table 
&lt;BR /&gt;Here row10.survey_table is a dynamic which depends on sid, it may exists to some or may not to some ID's. 
&lt;BR /&gt;My intention is to skip the exception when row10.table_1 is not existing. 
&lt;BR /&gt;Please find my Job 
&lt;BR /&gt; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBcm.jpg"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/140875iB9F536F05DD88404/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MBcm.jpg" alt="0683p000009MBcm.jpg" /&gt;&lt;/span&gt;</description>
      <pubDate>Mon, 04 Nov 2013 13:57:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Skip-exception-on-tMysqlInput-component/m-p/2286353#M59975</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-11-04T13:57:42Z</dc:date>
    </item>
    <item>
      <title>Re: Skip exception on tMysqlInput component</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Skip-exception-on-tMysqlInput-component/m-p/2286354#M59976</link>
      <description>I would check if the table exists before. MySQL provides and information schema for every database. I would dig in these tables to get the information if the table exists.</description>
      <pubDate>Mon, 04 Nov 2013 19:24:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Skip-exception-on-tMysqlInput-component/m-p/2286354#M59976</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-11-04T19:24:24Z</dc:date>
    </item>
  </channel>
</rss>

