2 Replies Latest reply: May 3, 2017 9:47 PM by Anil Samineni RSS

    Load from list of files only if file has data.

    m m

      i have few text files that gets generated everyday. Header of files gets generated every single time (hence it is not "Zero" in size) however weekend files dont have any data in them. I want to merge those files into 1 file for each.....


      Need help writing script.




      Load 0 as field1 autogenerate 0;



      For each vFile in FileList('temp2016*.txt')


      if file is greater then 1 record then

      concatenate (temptable)


      otherwise don't concatenate and move on to next file.