topic Re: Replace multiple fields data in QlikView

Replace multiple fields data

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to replace , with . in multiple fields ?

Ex: I have 30 fields, in which I have to replace ,(comma) with .(dot) -- in Qlikview script itself

I know that, replace function can be used for this purpose but I need to write it for every field.

So is there any possibility to replace all the 30 fields data at a time ?

Regards

mohan

Re: Replace multiple fields data

Anil_Babu_Samineni — Wed, 11 Apr 2018 12:32:21 GMT

Does 30 fields are in same table?

Re: Replace multiple fields data

stabben23 — Wed, 11 Apr 2018 12:36:16 GMT

change here maybe?

Re: Replace multiple fields data

mohan2391 — Wed, 11 Apr 2018 13:31:28 GMT

YES

Re: Replace multiple fields data

mohan2391 — Wed, 11 Apr 2018 13:32:55 GMT

If I use this, it will effect in all fields, right.

but i want to change in those 30 only there are lot more fields in that table available.

Re: Replace multiple fields data

stabben23 — Wed, 11 Apr 2018 13:36:24 GMT

Havent test but if you change back after this table, for ex

SET DecimalSep='.';
LOAD
;
from your table;

SET DecimalSep=',';

Re: Replace multiple fields data

sudhirpkuwar — Wed, 11 Apr 2018 13:47:01 GMT

Better is to write replace() for every field individually

Re: Replace multiple fields data

stabben23 — Wed, 11 Apr 2018 13:49:10 GMT

or this maybe

SET DecimalSep='.';
//first 30 field with .
LOAD
ItemId,
Field1,
Field2

FROM
[create.xlsx]
(ooxml, embedded labels, table is Blad1);

SET DecimalSep=',';

//join other field with ,
join LOAD
ItemId,
Field3,
Field4
FROM
[create.xlsx]
(ooxml, embedded labels, table is Blad1);