Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading in data from a .tsv file
TBL_USERPROFILES:
GENERIC LOAD
// ProfileID,
UserID,
// PropertyDefinitionID,
// PropertyCategory,
PropertyName,
Capitalize(PropertyValue)
// LastUpdatedDate
FROM
[User_Profiles.tsv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
I receive the following error message. Is the error in the data or the script? What would the fix be?
Blank field name not allowed
TBL_USERPROFILES:
GENERIC LOAD
UserID,
PropertyName,
Capitalize(PropertyValue)
FROM
[User_Profiles.tsv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
Does your third field has any values?
I tried this and also added to the other fields and still received the same error
Thanks for the feedback evansabres.
Would it be possible to share sample file, so that I can do some troubleshooting on my side?
Regards
Rajiv.
ProfileID | UserID | PropertyDefinitionID | PropertyCategory | PropertyName | PropertyValue | LastUpdatedDate |
4766525 | 718984 | 1577 | Name | FirstName | Words | 5/18/2016 19:55 |
4766526 | 718984 | 1579 | Name | LastName | Admin | 5/18/2016 19:55 |
4949112 | 740486 | 1567 | Social Stream | FacebookID | 1234567 | 6/30/2016 18:03 |
4949113 | 740486 | 1568 | Social Stream | FacebookToken | EA124 | 6/30/2016 18:03 |
5073257 | 756870 | 1577 | Name | FirstName | Nico | 7/28/2016 18:34 |
5073258 | 756870 | 1579 | Name | LastName | Richards | 7/28/2016 18:34 |
5190305 | 778588 | 1577 | Name | FirstName | Dave | 8/11/2016 21:58 |
5190306 | 778588 | 1579 | Name | LastName | Smith | 8/11/2016 21:58 |
5190307 | 778588 | 1586 | Address | PostalCode | 5451 | 8/11/2016 21:58 |
ok. I just added some of your data at my end and i did generic load it worked fine. May be some problem with your delimiter \t. Can you upload your .tsv file here if possible?
Hi Evan
I tried the load on my side by creating a sample file with your data. It worked fine for now. Can you please use this file (replace the path with your file path and see if it works?
Regards
Rajiv.
I still get the same error. I need to check into my data source to see if there is any potential the issue lies there
PropertyName
contains empty strings or null values?
Works just fine for me:
TBL_USERPROFILES:
GENERIC LOAD
UserID,
PropertyName,
Capitalize(PropertyValue) AS PropertyValue
FROM
[https://community.qlik.com/thread/314215]
(html, codepage is 1252, embedded labels, table is @1);
I assume the PropertyName field shows blanks or NULL, so maybe try to check your input data file or use something like
TBL_USERPROFILES:
GENERIC LOAD
UserID,
If(Len(Trim(PropertyName)),PropertyName,'DummyField') as PropertyName,
Capitalize(PropertyValue) AS PropertyValue
FROM
[https://community.qlik.com/thread/314215]
(html, codepage is 1252, embedded labels, table is @1);
Thanks. Please have a check on data quality to see if any of the column bring any blank or null value. If not, your script should run perfectly. Just as a last check try the following:
TBL_USERPROFILES:
GENERIC LOAD
IF(ISNULL(UserID), 'Other', UserID) AS UserID,
IF(ISNULL(PropertyName), 'Other', PropertyName) AS PropertyName,
IF(ISNULL(PropertyValue), 'Other', PropertyValue) AS PropertyValue
FROM
[User_Profiles.tsv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
Regards
Rajiv.