Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Skip exception on tMysqlInput component

I am trying to skip the exception on tMysqlInput component. My Query is simple like
"SELECT "+row10.sid+" ,"+row10.qid+" ,"+row10.parent_qid+" ,"+row10.gid+" ,
"+row10.survey_table+"."+row10.survey_title+" as response,id as response_id
FROM "+row10.survey_table
Here row10.survey_table is a dynamic which depends on sid, it may exists to some or may not to some ID's.
My intention is to skip the exception when row10.table_1 is not existing.
Please find my Job
0683p000009MBcm.jpg
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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.