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)

[evansabres]

The latter part of your response functioned:

TBL_USERPROFILES:

GENERIC LOAD

    UserID,

    If(Len(Trim(PropertyName)),PropertyName,'DummyField') as PropertyName,

    Capitalize(PropertyValue) AS PropertyValue

FROM

(html, codepage is 1252, embedded labels, table is @1);