Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i put string in FROM??

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

1 Solution

Accepted Solutions
john9inno
Creator
Creator

change vLocation as $(vLocation)

also "set" will work instead of "let"

View solution in original post

1 Reply
john9inno
Creator
Creator

change vLocation as $(vLocation)

also "set" will work instead of "let"