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
Maybe something like this:
if noofrows('PAYMENT') >= 1 then
View solution in original post
Thank you very much marcus_sommer