Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone!!
i'm working on this data and i've got this column called "yearmonthresolution", but as you can see there are some cells that not contain dates but only a "-". so someone can suggest me what kind of string should i use to replace all the "-" with "open".
Thanks
in your load script
load
.....
if(len(trim(yearmonthresolution))=0, 'open', yearmonthresolution) as yearmonthresolution,
.....
from
......;
in your load script
load
.....
if(len(trim(yearmonthresolution))=0, 'open', yearmonthresolution) as yearmonthresolution,
.....
from
......;
Ti suggerisco di fare questa operazione nello script per garantire uniformità dei dati:
Quando carichi la tabella contenente il campo yearmonthresolution scrivi:
Load
...
If(IsNull(yearmonthresolution) or trim(yearmonthresolution)='', 'Open', yearmonthresolution) as yearmonthresolution
...
Resident ...
Se il problema non si risolve, significa che fai una join o esiste un'associazione che genera tale situazione, nel caso cerchiamo di trovare un'altra soluzione.
Fammi sapere
Dear ,
can you try to load the below table before your table.
Map_Nulls:
Mapping LOAD
NULL(),'open'
AutoGenerate 1;
MAP 'yearmonthresolution' using Map_Nulls;
i hope it will help you.
Thanks,
Mukram.
Hi Gabriele,
I guess this is a straight table. Go to the 'Presentation' tab in the 'Chart Properties' menu and type 'Open' into the 'Null Symbol' check box. That's all.
Hope this helps
Burkhard
Hi,
You can replace null with zeros.
Look at the attached application.
Regards
ASHFAQ