Missing data - Nulls?

[bazzaonline]

Hello,

Really new to this and need to work out how to replace empty field with defined text in the script.

Example attached, where this is no name eg ' - ', how can I replace this in the script to a default, for example 'Temp'?

  Make 5 and 6 have Temp in Responsible??

[Anonymous]

Try something like this in you load script.

LOAD Activity,

     if ( isnull (Responsible) , 'Temp' , Responsible )      as Responsible

FROM

(ooxml, embedded labels, table is Sheet1);

[tyagishaila]

Go to Chart Properties>> presentation Tab

There are two options 1 for NULL Symbol and another for Missing Symbol.

You can Type there whatever you want in place of missing symbol/Null symbol.

I hope your problem will resolve.

[AbhijitBansode]

The best way to deal with NULLs is:

LOAD Activity,

     if ( Len (Responsible) <1, 'Temp' , Responsible )      as Responsible

FROM

(ooxml, embedded labels, table is Sheet1);

[#5]

Hi Paul

goto: point to the chart->chart properties->Presentation (tab)-> Null Symbols=Temp /Missing Symbol = Temp.

this is the easiest way, otherwise you can perform this in your script as Abhijit suggested or in you chart dimensions put a an if condition .

Hope this helps

Best Regards

Dlamini