Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
FrankC
Contributor III
Contributor III

abort a load

Hello

 

Is there a way to either fail a task or about a load if the database doesn't have current data?

 

thanks in advance

Frank

Labels (1)
  • Other

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

You need to check in any way if there are newer/changed data and depending on the result you may exit the load per exit script;  (means a successful task) or to force a intentionally failure like: load * from NotExistingTable; and the script breaks with an error and you get an appropriate error-message. This mustn't be mandatory be included within the origin load else it might be done within a task in beforehand.

Another approach could be not to use a time-depending trigger in the qmc else to make the appropriate check within the database which then execute the Qlik tasks per EDX.

- Marcus 

View solution in original post

2 Replies
Qlik1_User1
Creator III
Creator III

@FrankC ,

Try, IF condition on Date field having current dates before loading whole table.

marcus_sommer
MVP & Luminary
MVP & Luminary

You need to check in any way if there are newer/changed data and depending on the result you may exit the load per exit script;  (means a successful task) or to force a intentionally failure like: load * from NotExistingTable; and the script breaks with an error and you get an appropriate error-message. This mustn't be mandatory be included within the origin load else it might be done within a task in beforehand.

Another approach could be not to use a time-depending trigger in the qmc else to make the appropriate check within the database which then execute the Qlik tasks per EDX.

- Marcus 

View solution in original post