2 Replies Latest reply: Oct 10, 2016 6:18 AM by Simon Baxter RSS

    Only save to text file in script if data is present

    Simon Baxter

      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