How to remove null() or empty spaces in Table Box

[ravikumar_iyana]

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

[agigliotti]

in View or Sense ?

[ravikumar_iyana]

In View

[Quy_Nguyen]

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.

[agigliotti]

try below in script:

if( len(trim(Teacher))=0, null(), Teacher ) as Teacher

and check Omit rows where field is null.

[ravikumar_iyana]

Hi Andrea,

I am tried that Omit rows

Buts its not working

[agigliotti]

are you sure the "Teacher" field value for student "John" is blank ?

[shraddha_g]

is it blank or null?

[Chanty4u]

try

If(isnull(Teacher) , Null(), Teacher) As Teacher

[saniyask]

Hi,

hope this helps.

Regards,

Saniya