Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing a problem for removing null() or spaces in tablebox.
Teacher | student |
John | |
ravi | Reddy |
kumar | Prem |
sai | Kumar |
anil | runil |
teja | mani |
shiva | krishna |
Requirement: when Tab:Teacher is null then all Column will disappear
I am already used this below:
1) I am already used trim() in script level
2) In Table Box -> presentation -> i am checked Omit Rows where field is null
plz help me ASAP
in View or Sense ?
In View
Hi Ravi,
If you want to treat spaces as null, try this in the script load:
If(Trim(Teacher) = '', Null(), Teacher) As Teacher
Then In Table Box -> presentation -> check Omit Rows where field is null.
try below in script:
if( len(trim(Teacher))=0, null(), Teacher ) as Teacher
and check Omit rows where field is null.
Hi Andrea,
I am tried that Omit rows
Buts its not working
are you sure the "Teacher" field value for student "John" is blank ?
is it blank or null?
try
If(isnull(Teacher) , Null(), Teacher) As Teacher
Hi,
hope this helps.
Regards,
Saniya