Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Is this possible?

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.

1 Solution

Accepted Solutions
bramkn
Partner - Specialist
Partner - Specialist

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.

View solution in original post

7 Replies
Anonymous
Not applicable

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

bramkn
Partner - Specialist
Partner - Specialist

you will have to build in a check for this and use the notification connector to send a notification.

rittermd
Master
Master
Author

Can you expand on this at all?

bramkn
Partner - Specialist
Partner - Specialist

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.

shivanandk
Partner - Creator II
Partner - Creator II

rittermd
Master
Master
Author

That helped a lot.  Thank you.  I will give it a try.

bramkn
Partner - Specialist
Partner - Specialist

Goodluck feel free to ask if you can't get it to work.