i have a select sql and a field cointains a value null.
I create a table
LOAD * INLINE [
" ", Jenny
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
If(IsNull(Num) or Len(Trim(Num))=0, 999, Num) as Num,
LOAD * INLINE[
If(IsNull(Num),'null',Num) as Num,,Name
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
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
Retrieving data ...