Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a select sql and a field cointains a value null.
I create a table
LOAD * INLINE [
Num, Name
" ", Jenny
2, Febrizio
3, Mark
and the column Num is joined to another field NumId
The problem is the missing of data when I use a pivot table
You can associate any other value (say 999) whenver Num is blank or null. Use below in script
Load
If(IsNull(Num) or Len(Trim(Num))=0, 999, Num) as Num,
Name
From....
Try this.
Table:
LOAD * INLINE[
If(IsNull(Num),'null',Num) as Num,,Name
" ",Jenny
2,Febrizo
3,Mark
];
hi,
it seems all correct but when i create a bar chart, i have this misalignment.
The value null ... has a bar on his own.
and the name ... hasn't values
hi,
Solved
My starting field was 5 (value null)
ahi ahi ahii
Boa tarde Fábio
Como ele faz parte da chave, no script ETL sugiro que atribua 0 (zero) ao campo caso seja nulo.
Algo assim: LOAD ..., If(IsNull(Num), 0, Num) As %NumID