Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
FrankC
Creator
Creator

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

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
Specialist
Specialist

@FrankC ,

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

marcus_sommer

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