Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community I need help.
I'm trying to automate process of loading the newest xlsx file in qvw and i wrote a script that should do just that.
I'm stuck at the point where I need to transfer value stored in variable to the path of loaded xlsx. I've tried everything. Using LET, SET...
Plesae help me because I'm stuck here...
Code:
SET vMaxDate = MAX(Mid(FN.Filename,Len(FN.Filename)-11,8));
//Load Phonebook entries
AC_temp:
LOAD
Lower(Email) AS %email,
DN,
PersonnelID,
FullName,
FamilyName,
ChristianName,
Country,
OU,
OUName,
PhoneNumber,
MobileNumber,
Company,
Position,
DivisionID,
DivisionName,
All_OUs,
OU_Count
FROM
C:\Users\mydocuments\Qlik_Training\BL_obsolete\DEV\B_L_obsolete\0150_RawData\CSV\Phonebook.$(vMaxDate).csv
(txt, codepage is 1250, embedded labels, delimiter is ';', msq);
If your question has been answered to satisfaction, please close the discussion by marking an answer as Correct. That answer will appear in the same frame as your original post at the top, making it easier for other Community Members to find Question & Answer. Thanks.
Peter
And marking the correct answer also helps others to not waste time reading an already solved thread.
Thank you Peter once more.
My pleasure.
Enjoy QlikView and the Qlik Community.