Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
If I was confused it was association, I will close the thread and create it correctly.
Thank you
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')
If I was confused it was association, I will close the thread and create it correctly.
Thank you