Only save to text file in script if data is present

Mon, 10 Oct 2016 09:53:00 GMT

Hi Experts,

I have a script that stores the contents of a table into a text file every hour with the last hours data using a where clause when I load in the data to the table.

store PAYMENT into '\\Data Team\Hourly_Deltas\PAYMENT_DELTA-'$(vDateTime).txt (txt, delimiter is ',');

This works very well, BUT, what I would like to do is to only store the table as a text if there is data there, is there a way to do this?

So, sometimes there is no data and I get a text file with just field headers in it, I only want the text files if there is data as well as field headers.

Thank you for your help, Simon

Re: Only save to text file in script if data is present

marcus_sommer — Mon, 10 Oct 2016 09:55:22 GMT

Maybe something like this:

if noofrows('PAYMENT') >= 1 then

store ....

end if

- Marcus

Re: Only save to text file in script if data is present

Mon, 10 Oct 2016 10:18:51 GMT

Thank you very much marcus_sommer‌

topic Re: Only save to text file in script if data is present in QlikView

Only save to text file in script if data is present

Re: Only save to text file in script if data is present

Re: Only save to text file in script if data is present