Error Trap

If at first you don’t succeed, Error Trap! Sometimes things go wrong…. Sometimes if you wait a few seconds and try again it works. Strange but true!

Here we look at error traps. In Qlik rather than getting a failed job we can make the code wait for as long as you want and try again as many times as you like.

I use these often when the source SQL database can be a bit temperamental and I combine it with the Audit Log so I know exactly what’s going on.

Hope you all find it useful and I look forward to hearing your comments and if you have any tricks and tips like this you’d like to share.

Cheers

Richard

Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!

https://www.youtube.com/watch?v=-RTW9zUa4jk

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s