Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
change vLocation as $(vLocation)
also "set" will work instead of "let"
change vLocation as $(vLocation)
also "set" will work instead of "let"