Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to replace text values(fields) in a column by other text values?

Hi Experts,

How to replace text values in a column by other text values? and i want to do it in the load script

Example:

sampledata.png

1. How to replace in the column DATA1 the fields Dessine by Dessiné ?

2. How to replace in the column DATA 2 the fields .5 by  windows7 ?

Supposed that i load the Data like this:

LOAD [DATA 1],

     [DATA 2]

FROM

C:\Users\mydata\Desktop\sample_data.xlsx

(ooxml, embedded labels, table is Feuil1);

what should i do to transform my data ?

Thanx

Regards

Ali

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to replace text values(fields) in a column by other text values?

Hi,

Try using the Applymap function.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/MappingFunctions/ApplyM...

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator
Creator

Re: How to replace text values(fields) in a column by other text values?

Thanx i will tell u if it works

Highlighted

Re: How to replace text values(fields) in a column by other text values?

Also, look here:

Data Cleansing

Highlighted

Re: How to replace text values(fields) in a column by other text values?

Either you can introduce any new table with Joins, Concatenation or Mapping with the help of one of this you can get change the text values in the existing values.

Highlighted
Creator II
Creator II

Re: How to replace text values(fields) in a column by other text values?

Hi,

may be you can create inline table.

Ex:

[Inline 1]:

Load * Inline

[

DATA 1,Data 1

Dessine,Dessiné

];

[INLINE TABLE2]:

Load * Inline

[

  DATA 2,Data 2

  .5,windows7

];

And use Data 1 instead of DATA 1  and Data 2 instead of DATA 2.

Highlighted
Creator
Creator

Re: How to replace text values(fields) in a column by other text values?

Try,

Replace your column field with the below condition and give the column alias:

If([Data 1] = 'Dessine', 'Dessiné', [Data 1]) as Column_Alias

If([Data 2] = .5, 'Windows7', [Data 2]) as Column_Alias

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com