Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
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
sunny_talwar

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
sunny_talwar

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";
VishalWaghole
Specialist II
Specialist II

Try this,

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