topic Using Rename Fields from Mapping Table in QlikView

Using Rename Fields from Mapping Table

mantaq10 — Mon, 24 May 2010 09:01:18 GMT

HI all,

I am trying to rename fields from a mapping table as described in the reference manual (page 325). However, I am getting an error "invalid object name: dict".

What am I doing wrong here?


dict:
MAPPING LOAD * INLINE [
 OldName, NewName
 CustomerID, CustomerID1
 TerritoryID, TerritoryID1
 CustomerType, CustomerType1
];


FieldMap:
Mapping Select OldName, NewName from dict; //this is where error occurs.
Rename Fields using FieldMap;

Appreciate the help 🙂

Using Rename Fields from Mapping Table

Mon, 24 May 2010 09:20:47 GMT

In your FieldMap selection statement, you should use RESIDENT instead of FROM, so it should be:

Mapping Select OldName, NewName RESIDENT dict;

Using Rename Fields from Mapping Table

mantaq10 — Mon, 24 May 2010 19:55:26 GMT

Thanks for the response Nigel,

i tried the RESIDENT option but it ain't working either.

The error i get from both QV9 and 10b are attached...

QV9:

QV10:

Using Rename Fields from Mapping Table

boorgura — Mon, 24 May 2010 20:34:52 GMT

If I'm not wrong it should be mapping LOAD

and not mapping Select.

Let me know if it works.

Using Rename Fields from Mapping Table

mantaq10 — Mon, 24 May 2010 22:08:57 GMT

Mapping Load and Mapping Select are two different things as per the documentation.

Using Rename Fields from Mapping Table

rwunderlich — Tue, 25 May 2010 04:21:45 GMT

You don't need to create the FieldMap. You've already created the mapping table named "dict" in the INLINE. See below.

-Rob

dict:
MAPPING LOAD * INLINE [
OldName, NewName
CustomerID, CustomerID1
TerritoryID, TerritoryID1
CustomerType, CustomerType1
];

Rename Fields using dict;

Using Rename Fields from Mapping Table

mantaq10 — Tue, 06 Jul 2010 11:38:17 GMT

Thanks Rob 🙂