Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
my bad bruno. It did work. Thank you very much.
hi
Can you copy past the error message and may be post here a sample of your excel file ?
Bruno
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;
nice to read it works