2 Replies Latest reply: Jul 31, 2017 6:42 AM by Lukas Roček RSS

    Replace the record with others

    Lukas Roček

      Hi all,

      I have a problem with this code:




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


      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...