topic Re: Update Data of a table inside Qlikview app in QlikView

Update Data of a table inside Qlikview app

Architect — Thu, 29 Oct 2020 05:19:43 GMT

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 — Thu, 29 Oct 2020 06:21:50 GMT

Try like this

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

Architect — Thu, 29 Oct 2020 06:38:16 GMT

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 — Thu, 29 Oct 2020 06:51:10 GMT

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 — Thu, 29 Oct 2020 17:27:13 GMT

thanks, Vegar. Now it is solved.