Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to be able to send a notification when a file being processed in a script has zero records in it.
We are experiencing an issue with SCRIBE where it deletes the table but then gets hung up some times and doesn't put the data back. Until that gets fixed I occasionally process this table with no records. This does not trigger an error in the script currently.
So if I don't remember to check each day then I don't catch that it was empty. The dashboard loads but is wrong.
You load the data somewhere in the script right? Create a variable with = noofrows('table') And then use the notification connector to send an email when this value is 0/not higher than 0. hope this was clear enough.
Hi Mark,
As of now there is no functionality available for sending a notification when a file being processed in a script has zero records. If you need this functionality I'd look at QlikView as there is the option to trigger an email on load and also you have nPrinting which gives you more customization of how,when and to who you send emails.
Thank you!
Best Regards,
Sumit K
you will have to build in a check for this and use the notification connector to send a notification.
Can you expand on this at all?
You load the data somewhere in the script right? Create a variable with = noofrows('table') And then use the notification connector to send an email when this value is 0/not higher than 0. hope this was clear enough.
Check the Web connector Notification connector or Mailbox
That helped a lot. Thank you. I will give it a try.
Goodluck feel free to ask if you can't get it to work.