8 Replies Latest reply: Apr 17, 2018 10:17 AM by Daniel Rider RSS

    Create variable filename, and load from variable

      Howdy,

       

      I'm trying to create a variable in the load script, and use it as PART of the file name to load from.

       

      Why is my vNewestFolder working in the qvw itself, but not passing the value into the file name? I'm just trying to slip that variable in as part of my filepath

       

      set vNewestFolder = max(MaxFolder);

      set vFileName = 'D:\Apps2\CUSTOMER RELATIONS\VendorOrderStatus_Emails\' & $(vNewestFolder) & '*';

       

      DataLoad:

      LOAD *

      FROM

      [$(vFileName)]

      (ooxml, embedded labels, table is [*]);