Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Use
[GoalTab]:
LOAD
if(BU='A' or BU='B', 'AB', BU) as BU,
Goal
FROM [...path.xlsm]
(ooxml, embedded labels, table is GOAL);
Use
[GoalTab]:
LOAD
if(BU='A' or BU='B', 'AB', BU) as BU,
Goal
FROM [...path.xlsm]
(ooxml, embedded labels, table is GOAL);
Thank you very much