This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
This could be a good scenario where using an mapping table and ApplyMap could solve your issue.
Mapping Load * inline [
A type, Type Alfa
B type , Type Beta
Applymap('MAP', Type) as Type
View solution in original post
Try like this
Load *, Capitalize(SubField(Type, ' ',-1))&' '&Capitalize(SubField(Type, ' ',1)) as Type1 Inline[TypeA typeB type];
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.
thanks, Vegar. Now it is solved.