Replace the record with others

[Anonymous]

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

[prat1507 · Accepted solution]

Use

[GoalTab]:

LOAD

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

    Goal

FROM [...path.xlsm]

(ooxml, embedded labels, table is GOAL);

[Anonymous]

Thank you very much