Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Try something like this in you load script.
LOAD Activity,
if ( isnull (Responsible) , 'Temp' , Responsible ) as Responsible
FROM
(ooxml, embedded labels, table is Sheet1);
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.
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);
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