4 Replies Latest reply: Jan 19, 2015 2:30 PM by David Cohen RSS

    Load from Wildcard filename & extension/filetype

      Howdy,

       

      i'm trying to let my load script load from a wildcard file name and filetype.

       

      What is wrong with this script? keeps failing...

       

       

      TestData:

      Load

      orderNo,

      CustomerNo,

      Date

      From

      [D:\Apps2\CUSTOMER\VendorOrder\$(vNewestFolder)\*.*];

       

      The problem is, is that sometimes there will be NO files in this directory...and i just want it to return nothing if that's the case. Though if there are files...i want the script to run.

       

      Much thanks!

       

      -David