10 Replies Latest reply: Oct 17, 2017 12:18 PM by Mark Graham RSS

    Load files from folder

    Mark Graham

      All,

       

      I'm trying to only load files which have 9 am Timestamp.

       

      I tried below code - but this did not help.

       

      Load *

      FROM

      [..\TEST\*9 AM*.qvd]

      (qvd);

       

       

      Here is the example:

       

       

      Demand Master 2017-09-05  8 AM
      Demand Master 2017-09-05  9 AM
      Demand Master 2017-09-05  10 AM
      Demand Master 2017-09-05  11 AM
      Demand Master 2017-09-06  8 AM
      Demand Master 2017-09-06  9 AM
      Demand Master 2017-09-06  10 AM

      Demand Master 2017-09-06  11 AM

       

       

      Any help is highly appreciated!