Update Data of a table inside Qlikview app

[Architect]

In the Qlikview app, The requirement is as below -

There is a table 'Sales' taking data from DB. In the table, there is one column 'Types'.

now we have to update the data of the column as below--

'A type'--> 'Type A'

'B type'-->'Type B'

Roughly there are 3000 rows in the column 'Types'.

Please suggest how to resolve this issue inside the app without changing the source data.

[MayilVahanan]

Hi @Architect 

Try like this

Load *, Capitalize(SubField(Type, ' ',-1))&' '&Capitalize(SubField(Type, ' ',1)) as Type1 Inline
[
Type
A type
B type
];

[Architect]

Hi @MayilVahanan  thanks for the information.

Actually there are some other data too that has to be modified it is not only Capitalize.

new text has to be added to the data too.

and the modification is in the data level not the field level.

[Vegar · Accepted solution]

This could be a good scenario where using an mapping table and ApplyMap could solve your issue. 

Map:

Mapping Load * inline [

OrigType, NewType

A type, Type Alfa

B type , Type Beta

] ;

Load

Applymap('MAP', Type) as Type

From Source;

[Architect]

thanks, Vegar. Now it is solved.