Preceding load and join to main table - Qlikview changes the field name when it's not asked to

[#1]

Hello;

I'm just using a preceding load to derive a new field and add it to my MainTable (can't do this during the load for MainTable because the fields are actually derived after). So my problem now is, Qlikview adds the new field, but it changes the name of the NewFieldKey to Temp.NewFieldKey. However, I want to have it named as NewField because that's my key to link this MainTable to another table that I have.

TempComp:

LOAD

[Field1] & ' ' & [DerivedField] as NewFieldKey,

[ID]

;

Load

  [ID],

  [DerivedField],

  Field1

  Resident [MainTable];

Join (MainTable)

Load *

Resident TempComp;

Drop table TempComp;

[swuehl · Accepted solution]

It's not quite clear which fields need to be renamed and which not.

I assume like Sunny suggested to just use a Unqualify *;

Or

Unqualify  [ID],  [DerivedField],  Field1,     NewFieldKey;

Or unqualify whatever field names you need to.

[#3]

Thanks everyone!! Got it! I didn;t know that qualifier will remain effective until end of script!