2 Replies Latest reply: Jul 31, 2017 6:42 AM by Luk�? Ro?ek RSS

    Replace the record with others

    Luk�? Ro?ek

      Hi all,

      I have a problem with this code:

      [GoalTab]:

      LOAD

         

          if(BU='A' or BU='B', BU = 'AB', BU) as BU,

          Goal

      FROM [...path.xlsm]

      (ooxml, embedded labels, table is GOAL);

       

      I want to replace A or B by AB, but in vizualization is 0 (each other record is OK within AB...).

      Thanks for your answers...