topic Re: Blank field name not allowed in QlikView

Blank field name not allowed

evansabres — Mon, 17 Sep 2018 19:14:07 GMT

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)

Re: Blank field name not allowed

vamsee — Mon, 17 Sep 2018 19:35:42 GMT

Try

TBL_USERPROFILES:

GENERIC LOAD

UserID,

PropertyName,

[Capitalize(PropertyValue)]

FROM

[User_Profiles.tsv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 19:37:29 GMT

This changes to error to:

Field not found - <Capitalize(PropertyValue)>

TBL_USERPROFILES:

GENERIC LOAD

UserID,

PropertyName,

[Capitalize(PropertyValue)]

FROM

[User_Profiles.tsv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

Re: Blank field name not allowed

vishsaggi — Mon, 17 Sep 2018 19:45:50 GMT

Are you trying to make the Propertyvalue to upper case, may be use like

GENERIC

LOAD ......,

UPPER(PropertyValue) AS PropertyVal

FROM ......;

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 19:49:55 GMT

I unfortunately did not write the script, so I am not entirely certain what the intent was. Assuming they just wanted to capitalize the first letter, which would make Capitalize(txt) correct, what else could the issue be? Some values in that field are blank / numeric, could that be an issue?

Re: Blank field name not allowed

vishsaggi — Mon, 17 Sep 2018 19:56:34 GMT

Can you try like

Capitalize(PropertyValue) AS PropertyValue

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 19:58:15 GMT

Unfortunately, still receive same error:

Blank field name not allowed

TBL_USERPROFILES:

GENERIC LOAD

UserID,

PropertyName,

Capitalize(PropertyValue) AS PropertyValue

FROM

[User_Profiles.tsv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

Re: Blank field name not allowed

vishsaggi — Mon, 17 Sep 2018 20:05:08 GMT

Can you not use this Capitalize and just load the values as is and check?

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 20:09:50 GMT

Still generates the same error

Re: Blank field name not allowed

rajivmeher — Mon, 17 Sep 2018 20:36:14 GMT

Hi evansabres‌

Would it be possible to provide a sample file?

Please also try the following:

TBL_USERPROFILES:

GENERIC LOAD

UserID,

PropertyName,

IF(ISNULL(PropertyValue), 0, PropertyValue) AS PropertyValue

FROM

[User_Profiles.tsv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

I guess as this is a Generic Load, the query is expecting value on the third column and might not accept a blank or null.

Regards

Rajiv.

Re: Blank field name not allowed

vishsaggi — Mon, 17 Sep 2018 20:39:07 GMT

Does your third field has any values?

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 20:42:52 GMT

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

Re: Blank field name not allowed

rajivmeher — Mon, 17 Sep 2018 20:46:27 GMT

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.

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 20:49:10 GMT

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

Re: Blank field name not allowed

vishsaggi — Mon, 17 Sep 2018 21:02:57 GMT

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?

Re: Blank field name not allowed

rajivmeher — Mon, 17 Sep 2018 21:04:06 GMT

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.

Re: Blank field name not allowed

evansabres — Mon, 17 Sep 2018 21:09:13 GMT

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

Re: Blank field name not allowed

MarcoWedel — Mon, 17 Sep 2018 21:09:25 GMT

PropertyName

contains empty strings or null values?

Re: Blank field name not allowed

swuehl — Mon, 17 Sep 2018 21:10:46 GMT

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

Re: Blank field name not allowed

rajivmeher — Mon, 17 Sep 2018 21:14:34 GMT

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.