Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a Table Box with many fields and one of those fields, STATUS, has different values like SELECTED, INSPECTED and there are also null values (showed as -). I'd like to change the null values in order to have something like 'TO BE SELECTED'. I believe I could do this by applying the following as a calculated dimension to STATUS: =IF(ISNULL(STATUS),'TO BE SELECTED',STATUS) but the thing is that I can't apply calculated dimensions to a Table Box...
How could I do this? What solution do you recommend me to use?
Thank you!!!
In the script:
LOAD
IF(Len(Trim(STATUS))=0,'TO BE SELECTED',STATUS) as STATUS,
*
FROM ......
In the script:
LOAD
IF(Len(Trim(STATUS))=0,'TO BE SELECTED',STATUS) as STATUS,
*
FROM ......
You can do the same using below
Script Side
Change your STATUS line as
IF(LEN(TRIM(Replace(STATUS,'-','')))=0,'TO BE SELECTED',STATUS) as STATUS
UI SIDE (in Listbox, Calculated Dimensions)
IF(LEN(TRIM(Replace(STATUS,'-','')))=0,'TO BE SELECTED',STATUS)
Hope this helps..
Load your table like
Load
IF(STATUS= '-', 'TO BE SELECTED',STATUS) AS NewStatus
From Location
Hope this helps