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

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

bouderbc — Wed, 06 Sep 2017 13:05:19 GMT

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:

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

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

kaushiknsolanki — Wed, 06 Sep 2017 13:06:51 GMT

Hi,

Try using the Applymap function.

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

Regards,

Kaushik Solanki

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

bouderbc — Wed, 06 Sep 2017 13:12:30 GMT

Thanx i will tell u if it works

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

sunny_talwar — Wed, 06 Sep 2017 13:12:48 GMT

Also, look here:

Data Cleansing

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

its_anandrjs — Wed, 06 Sep 2017 13:19:12 GMT

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.

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

Neymar_Jr — Thu, 14 Sep 2017 05:54:03 GMT

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.

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

afsarshaikh — Thu, 14 Sep 2017 06:12:15 GMT

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