if problem

[#1]

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 

[maxgro · Accepted solution]

in your load script

load

.....

if(len(trim(yearmonthresolution))=0, 'open', yearmonthresolution) as yearmonthresolution,

.....

from

     ......;

[alexandros17]

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

[mdmukramali]

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.

[veidlburkhard]

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

[ashfaq_haseeb]

Hi,

You can replace null with zeros.

Look at the attached application.

Regards

ASHFAQ