Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

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
b_knuever
Contributor III

Re: Is this possible?

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.

7 Replies
sumitkulkarni
New Contributor III

Re: Is this possible?

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

b_knuever
Contributor III

Re: Is this possible?

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

rittermd
Honored Contributor

Re: Is this possible?

Can you expand on this at all?

b_knuever
Contributor III

Re: Is this possible?

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
Contributor II

Re: Is this possible?

rittermd
Honored Contributor

Re: Is this possible?

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

b_knuever
Contributor III

Re: Is this possible?

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

Community Browser