Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
Are you using Qualify Statement above the TempComp Table?
Try a
Unqualify NewFieldKey;
before your TempComp table load.
I am using Qualify Statement, but before this - for another table.
I am using Qualify Statement, but before this - for another table.
Hi Swuehl,
added "Unqualify NewFieldKey;" - didn;t work unfortunately
You might have to do Unqualify *; before the TempComp table.
May be like this:
Unqualify *;
TempComp:
LOAD
[Field1] & ' ' & [DerivedField] as NewFieldKey,
[ID]
;
Load
[ID],
[DerivedField],
Field1
Resident [MainTable];
Join (MainTable)
Load *
Resident TempComp;
Drop table TempComp;
"I am using Qualify Statement, but before this - for another table."
Qualify efects persists until end of script or a Unqualify. It´s not per-table
If this is linked to your previous post and you have used Qualify which is preceding table name in your fieldnames to meet your other requirement, you can use Unqualify to avoid certain fields unqualified.
QUALIFY *;
UNQUALIFY NewFieldKey;
Use Unqualify * after your required use of Qualify to avoid any impact on existing scripts.