Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Script Error

I am getting the following script error when attempting to load my data:

The following error occurred:
No qualified path for file: ***
 
The error occurred here:
TBL_USERPROFILES_1: LOAD Distinct UserID FROM "abc-smith".ro."vw_Data_User_Profiles"
 
Below is my load script:
 

LIB CONNECT TO 'NAME_SQL_Database_abc-smith-db-01.database.windows.net (team_john.doe)';

LOAD
UserID,
PropertyName,
PropertyValue;

TBL_USERPROFILES:
SELECT
UserID,
PropertyName,
PropertyValue
FROM "abc-smith".ro."vw_Data_User_Profiles";

//----- MERGE MULTIPLE TABLES TO ONE CLEAN OUTPUT --------------------------------------------------//

SET vListOfTables = ;
FOR vTableNo = 0 to NoOfTables()
LET vTableName = TableName($(vTableNo)) ;
If Subfield(vTableName,'.',1)='TBL_USERPROFILES' Then
LET vListOfTables = vListOfTables & If(Len(vListOfTables)>0,',') & Chr(39) & vTableName & Chr(39) ;
End If
Next vTableNo

TBL_USERPROFILES_1:
LOAD Distinct UserID
FROM "abc-smith".ro."vw_Data_User_Profiles";

FOR Each vTableName in $(vListOfTables)
Left Join (TBL_USERPROFILES_1) Load * Resident [$(vTableName)];
Drop Table [$(vTableName)];
Next vTableName

//----- CLEANSE REGION FIELDS IN USER PROFILES 1 ---------------------------------------------------//

TBL_USERPROFILES_2:
LOAD
UserID,
// FirstName,
// LastName,
FacebookID,
// FacebookToken,
// Photo,
Date(PurgeChar(Birthdate, '00:00')) as Birthdate,
// Year(Birthdate) as BirthYear,
// Street,
Capitalize(City) as City,
Upper(Region) as Region1,
PostalCode,
// Telephone,
Gender,
// Unit,
TwitterID
// TwitterToken,
// TwitterTokenSecret,
// TMAccountIDCollection,
// TicketAccountID,
// PreferredTimeZone,
// TDCAccountIDCollection,
// IsFirstTime,
// TMSyncedAccountIDCollection
Resident TBL_USERPROFILES_1;

DROP TABLE TBL_USERPROFILES_1;


//----- Add Age To UserProfile ---------------------------------------------------//

TBL_USERPROFILES_3:
LOAD
UserID,
FacebookID,
Birthdate,
Year(Birthdate) as BirthYear,
age(today(),Birthdate) as Age,
City,
Region1,
PostalCode,
Gender,
TwitterID

 

Resident TBL_USERPROFILES_2;
DROP TABLE TBL_USERPROFILES_2;

//----- Add Age Groups to UserProfiles ---------------------------------------------------//

TBL_USERPROFILES_4:
lOAD
UserID,
FacebookID,
Birthdate,
BirthYear,
Age,
City,
Region1,
PostalCode,
Gender,
TwitterID,
if(Age < 20, ' Under 20',
if(Age < 25, '20-24',
if(Age < 30, '25-29',
if(Age < 35, '30-34',
if(Age < 40, '35-39',
if(Age < 45, '40-44',
if(Age < 50, '45-49',
if(Age < 55, '50-54',
if(Age < 60, '55-59',
if(Age < 65, '60-64',
if(Age < 70, '65-69',
if(Age < 100, 'Older than 70')))))))))))) as AgeGroup


Resident TBL_USERPROFILES_3;
DROP TABLE TBL_USERPROFILES_3;

1 Solution

Accepted Solutions
Highlighted

Do you may be want to do SELECT, instead of LOAD

TBL_USERPROFILES_1:
LOAD SELECT Distinct UserID
FROM "abc-smith".ro."vw_Data_User_Profiles";

View solution in original post

2 Replies
Highlighted

Do you may be want to do SELECT, instead of LOAD

TBL_USERPROFILES_1:
LOAD SELECT Distinct UserID
FROM "abc-smith".ro."vw_Data_User_Profiles";

View solution in original post

Specialist II
Specialist II

Try this,

LOAD
UserID,
PropertyName,
PropertyValue;
SELECT
UserID,
PropertyName,
PropertyValue
FROM "abc-smith".ro."vw_Data_User_Profiles";