topic Re: Modify field value in a table in QlikView

Modify field value in a table

Thu, 09 Jan 2014 10:23:05 GMT

Hello and Happy New Year Experts,

I have a table like shown below:

marque:

load mid([Field0_], 5) as Désignation,

[Field1_] as Emballage,

[Field2_] as Contenu,

[Field3_] as [Nb Cols],

[Field4_] as [Nb Pals],

[Field5_] as [Nb Litres]

resident ZSD_EGF_COMLIVSAISI

There is my problem: i wanna replace all the ',' by '.' in the column 'Contenu' but i don't know how to modify the value of this field.

It should be something like this:

replace([Field2_], ',', '.')

But this obviously don't work.

Can anyone help me for this?

Thanks for your replies,

Best Regards,

Loïc

Re: Modify field value in a table

Thu, 09 Jan 2014 10:31:09 GMT

Hi,

You can do the following:

marque:

load mid([Field0_], 5) as Désignation,

[Field1_] as Emballage,

[Field2_] as Contenu,

[Field3_] as [Nb Cols],

[Field4_] as [Nb Pals],

[Field5_] as [Nb Litres]

resident ZSD_EGF_COMLIVSAISI;

Temp:

Load *,

Replace (Contenu,',','.') as Contenu_changed;

Hope this helps!

Re: Modify field value in a table

swuehl — Thu, 09 Jan 2014 10:33:20 GMT

What do you mean with 'obviously' don't work.

It should work, so please post some sample data so we can see the obvious.

Re: Modify field value in a table

salto — Thu, 09 Jan 2014 10:38:18 GMT

Hi,

replace([Field2_], ',', '.') as Contenu,

should do the work...

Re: Modify field value in a table

Thu, 09 Jan 2014 10:51:49 GMT

Thanks for your replies!

The column 'Contenu' still has values like '0,200' so the content does not updated in the table

Re: Modify field value in a table

swuehl — Thu, 09 Jan 2014 11:09:24 GMT

Seems to work for me, only dots after replace:

marque:

load

replace([Field2_],',','.') as Contenu

INLINE [

Field2_

",,.."

];

Are you trying to change a number format? Then look into the default format variables and num() function.

SET ThousandSep=',';

SET DecimalSep='.';

Re: Modify field value in a table

Thu, 09 Jan 2014 11:21:54 GMT

Hi Ioic,

Please find the attachment, may it helps you.

Santhosh G

Re: Modify field value in a table

Thu, 09 Jan 2014 12:39:59 GMT

Thank you very much!

This is always easier to understand with an example