1 Reply Latest reply: Feb 13, 2017 7:02 PM by john gu RSS

    Can i put string in FROM??

    swana woo

      I want to load data daily and the csv data file is stored as a name with month-date-year

       

      LET vDate = Date(Today());

      LET vMonth = Month(Today());

      LET vYear = Year(Today());

      Let vLocation = 'lib://Downloads/score-'&vMonth&'-13-2017.csv';

       

      LOAD

          "Player Name",

          "Team Name",

          "Player Type",

          "Salary",

          "Date",

          "Player Rank",

          "Score"

      FROM vLocation

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

      but it's not working with vLocation in From statement.

      Is there anybody can help me? thank you in advance