6 Replies Latest reply: Jan 12, 2016 12:04 PM by bruno bertels RSS

    Replace values under column in script

    patrico mesri

      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.