Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
@FrankC ,
Try, IF condition on Date field having current dates before loading whole table.
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