5 Replies Latest reply: Jul 27, 2014 5:55 AM by Jhondel Escaner RSS

    How to load data from a variable file path?

      Hi Everyone,

       

      how can i use  variable with file path("[C:\Users\jhondel\Desktop\smdr.data.xlsx]") value and use it as my data source.

       

      example:

      in my sheet 1, I have created a input box and variable "file_pathname" with the value of " [C:\Users\jhondel\Desktop\smdr.data.xlsx]".

      i need "file_pathname" to be my data source

       

      LOAD

         Call_Start,

         Call_End

      FROM

      "file_pathname"

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      is this possible?

       

      Thanks,

       

      Jhondel