7 Replies Latest reply: Jan 16, 2015 1:50 PM by David Cohen 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 [*]);