topic Re: Replace values under column in script in App Development

Replace values under column in script

patriciousa — Tue, 12 Jan 2016 05:14:22 GMT

HI everyone. I have searched and used every post in this forum but nothing seems to work on me.

I love the app is easy to use and Im already creating some good graphs. Now i have this issue:

MY script:

load

name,

sale

from excel1;

load

name,

sale

from excel2;

load

name,

sale

from excel3;

the sale column has only 2 possibles values, Y or N.

i Want to change the Y to Yes and the N to No in qlik sense. I could do it easily by doing ctrl+f in each excel but i want to do it in qlik.

thank you

regards.

‌

Re: Replace values under column in script

brunobertels — Tue, 12 Jan 2016 08:04:04 GMT

Hi Patricio

Try this in each load script :

MY script:

load

name,

sale,

if(sale='Y','YES','NO') as SALE_long_value

from excel1;

etc with excel 2 and Excel 3

Regards

Bruno

Re: Replace values under column in script

patriciousa — Tue, 12 Jan 2016 12:30:48 GMT

‌thank you for your reply bruno but I'm receiving an error message that there is an error when I add what you said.

thank you

regards

Re: Replace values under column in script

patriciousa — Tue, 12 Jan 2016 12:35:49 GMT

‌my bad bruno. It did work. Thank you very much.

Re: Replace values under column in script

brunobertels — Tue, 12 Jan 2016 16:34:45 GMT

Can you copy past the error message and may be post here a sample of your excel file ?

Bruno

Re: Replace values under column in script

brunobertels — Tue, 12 Jan 2016 16:52:44 GMT

perhaps it's just the single quote arround the Y

try this :

MY script:

load

name,

sale,

if(sale=Y,'YES','NO') as SALE_long_value

from excel1;

Re: Replace values under column in script

brunobertels — Tue, 12 Jan 2016 17:04:21 GMT

nice to read it works