Replace Null With Value after association

[Mark_76]

Hello everyone,

I'm having trouble replacing nulls with value after join

If someone could help me I would appreciate it.

TableHechos:

LOAD

    regionCode,

    regionName,

    gpNum,

    DETALLE,

    Mes,

    Valor,

    GESTION

FROM [lib://AttachedFiles/BD.xlsx]

(ooxml, embedded labels, table is Hoja1);

Parametro:

LOAD

    gpNum,

    "CTA DETALLE",

    KPI

FROM [lib://AttachedFiles/BD.xlsx]

(ooxml, embedded labels, table is Hoja2);

[stevejoyce]

Your load script you posted doesn't have any joins nor the Gpflag field.  But you can use coalesce function to set a null value on a field:  example:  coalesce([field], 'n/a')

[Mark_76 · Accepted solution]

If I was confused it was association, I will close the thread and create it correctly.
Thank you