Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Can i put string in FROM??

change vLocation as $(vLocation)

also "set" will work instead of "let"

1 Reply
john9inno
Not applicable

Re: Can i put string in FROM??

change vLocation as $(vLocation)

also "set" will work instead of "let"