7 Replies Latest reply: Apr 8, 2018 9:37 AM by Yaniv Ben Malka RSS

    Store with variable file name (CSV)

    Yaniv Ben Malka

      Hi All,

       

      I try to save to a CSV file using STORE command with a variable in the file name.

       

      I get the variable name $(vText) in the file name, like this: Test_$(vText).csv

       

      Here is my script, I narrowed it down to be the least complicated possible:

       

      Let vText= 'SomeText';
      InventoryDailyReport:
      LOAD
          TransactionType,
          DateThisReportGenerated,
          InventoryAsOfDate,
          InventoryAsOfTime,
          PlantCode
      FROM [lib://Microsemi EDI_Schema (win-n5h9rv84sq3_administrator)/InventoryDailyReport_Temp2.qvd](qvd);
         
      Store InventoryDailyReport into lib://CSV/Test_$(vText).csv(txt, delimiter is '|');

       

      I looked through many posts regarding this issue, without success.

       

      Any suggestions?

       

      Thanks!