Script Error

EvanBarrick — Thu, 07 Mar 2019 18:38:56 GMT

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;

Re: Script Error

sunny_talwar — Fri, 08 Mar 2019 02:10:25 GMT

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";

Re: Script Error

VishalWaghole — Fri, 08 Mar 2019 18:21:21 GMT

Try this,

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

topic Re: Script Error in App Development

Script Error

Re: Script Error

Re: Script Error