Blank field name not allowed

[evansabres]

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)

[vishsaggi]

Does your third field has any values?

[evansabres]

I tried this and also added to the other fields and still received the same error

[rajivmeher]

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.

[evansabres]

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

[vishsaggi]

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?

[rajivmeher]

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.

[evansabres]

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

[MarcoWedel]

PropertyName

contains empty strings or null values?

[swuehl · Accepted solution]

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

[rajivmeher]

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.