Set analysis to get only values where len is greater than 1

[kamal_sanguri]

Hi All,

I am creating a straight table the data is in excel and has some blank cells.. In my straight table I do not want to show blank items.

I know I can filter them out with WHERE clause in script itself... however trying to learn how it can be done with SET ANALYSIS.

Here is something which I am trying:

only({1 <len(Description) = {">1"}> } Description)

Any help on this would be highly appreciated.

Thanks,

Kamal

[jerem1234 · Accepted solution]

try:

only({1<Description = {"=len(trim(Description)) >=1"}>} Description)

-trim will remove any spaces to count them as blanks as well

Hope this helps!

[Anonymous]

Try

only({1 <Description = {"=len(Description)>1"}> } Description)

[kamal_sanguri]

just one word....

AWESOME

[kamal_sanguri]

sure.. it helped.... thanks much

Cheers,

Kamal

[kamal_sanguri]

If you can elaborate it more...

why did we use "Description =" then criteria..

only({1<Description = {"=len(trim(Description)) >=1"}>} Description)

[Anonymous]

Because in set modifier we specify field and selection criteria for this field.  That is

Field = {...}

We cannot use an expression in place of field.