Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
Creator

Update Data of a table inside Qlikview app

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.

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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;

View solution in original post

4 Replies
MayilVahanan

Hi @Architect 

Try like this

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

Thanks & Regards,
Mayil Vahanan R
Architect
Creator
Creator
Author

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
MVP
MVP

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
Creator
Creator
Author

thanks, Vegar. Now it is solved.