Rename values in a field

[#1]

I want to take some values in some fields and rename them to a more user friendly name.

For instance I made a quick table below for an example but my data is coming from SQL. I want to take the values only in the fields and rename them to what is in field2 column.

Field1	Field2
Name1	NewName
Name2	NewName2
Name3	NewName3
Name4	NewName4

I am making both a list box and a graph where these names need to be updated.

Thanks.

[MK_QSL]

Can you elaborate your question and requirements with few line examples?

[its_anandrjs]

Hi,

From your point of view its seems that you load a table and what ever field name is there you load that one and want to give good understandable name but keep both the name am i correct or not please confirm.

Ex:-

Fieldname          NewName

name                    User_Name

Please explain more

Hope this helps

Thanks & Regards

[maxgro]

=Pick(wildmatch(FIELDNAME,

'Name1', 'Name2',  'Name3',   'Name4',     '*'), 

'NewName1', 'NewName2', 'NewName3', 'NewName4',  FIELDNAME)

[#5]

If there is a 1-1 relationship, you can display Field2 in your listbox or your graph.

If you really want to rename the content of field1, see MAPPING LOAD and APPLYMAP() function.

Fabrice

[#6]

create a mapping table

Maptest:

Mapping

Load * inline

[

Field1,	Field2
Name1,	NewName
Name2,	NewName2
Name3,	NewName3
Name4,	NewName4

];

use applymap function on your actual table while loading

ex: applymap('Maptest',Field1,'NA') as Fieldname

[its_anandrjs]

Hi,

If you maintain Field name in different table so make another reference table and join this table with current table or simply leave this table with like condition with any key see below code.

If this is your requirement.

TablefromSQL:

LOAD RowNo() as rowid,Field1;

load * Inline

[

Field1

Name1

Name2

Name3

Name4

];

ReferenceTable:

LOAD RowNo() as rowid,Field2;

Load * inline

[

Field1, Field2

Name1, NewName

Name2, NewName2

Name3, NewName3

Name4, NewName4

];

Hope this helps

Thanks & Regards

[#8]

I think this is what I need but still having some trouble putting it all together this is what I have now but I am still getting load errors.

ServerMap:

Mapping

Load * inline

[

Old Field Name, New Field Name

Server1, USA 1

Server2, USA 2

Server3, Mexico

Server4, EMEA

];

ALLDEVICEINFO:

SQL SELECT

DISTINCT A0.DISPLAYNAME AS "Device Name", A0.TYPE AS "Type", A1.OSTYPE AS "OS Name", A0.INVENTORYSERVER AS "Inventory Server"

ApplyMap('ServerMap',OldFieldName,'NA') as Fieldname

FROM Computer A0 (nolock) LEFT OUTER JOIN Operating_System A1 (nolock) ON A0.Computer_Idn = A1.Computer_Idn 

WHERE (A0.DEVICENAME IS NOT NULL)   ORDER BY  A0.DISPLAYNAME

[#9]

applymap is a qlikview specific function. you will have use preceding load to get it work.

ex:

Load Field1,field2, applymap() as field3;

sql select * from table1;

[#10]

Something like:

ServerMap:

Mapping

Load * inline

[

Old Field Name, New Field Name

Server1, USA 1

Server2, USA 2

Server3, Mexico

Server4, EMEA

];

ApplyMap('ServerMap',OldFieldName,'NA') as Fieldname

ALLDEVICEINFO:

SQL SELECT

DISTINCT A0.DISPLAYNAME AS "Device Name", A0.TYPE AS "Type", A1.OSTYPE AS "OS Name", A0.INVENTORYSERVER AS "Inventory Server"

FROM Computer A0 (nolock) LEFT OUTER JOIN Operating_System A1 (nolock) ON A0.Computer_Idn = A1.Computer_Idn

WHERE (A0.DEVICENAME IS NOT NULL)   ORDER BY  A0.DISPLAYNAME