Blank Data Fields

[evansabres]

Hello -

I have a data set that looks similar to this :

STH ID                          Name

114412423                    John Smith

                                      Dave Roberts

134514335                    Joe Davis

                                      Richard Smhelik

124541355                    Maxim Tsyplakov

123413413                    Robert Afinogenov

I am trying to create a list box that lists only the fields from STH ID that have a value?

How can I do this.

Thank you/

[#2]

Hi Evan,

create a listbox as an expression rather than a field with the following

If(isnum([STH ID]), Name)

should give the desired output

hope that helps

Joe

[#3]

See attached if that helps

[evansabres]

This makes the list box have both the STH id and the name, still returnig the fields that are blank.

My data table has 11,208 records, and rougly 1700 of them have STH ID....I want the list box to have only customers that have STH id

[engishfaque · Accepted solution]

Dear Evan,

Kindly find attached document.

Kind regards,

Ishfaque Ahmed

[#6]

Please see the attachment above , the listbox gives you the 4 names that have an ID only, which I think is what you are after?

Unless I have misunderstood

Joe

[evansabres]

Yes and No....My end goal is to create a button to allow the end user to 'Select All STH'....right now when you click the button, the action returns all fields under the heading STH_ID, including the blank fields.....my list box doesn't necessairly need to have the names of the STH, I just want to not include the blank fields....Again, I have 11,300 records, of which roughly 1800 have STH id's....is there an expression I can use within the list box to not return blank values?

Thanks so much for your help

[#8]

Not sure I totally understand what you mean, but if you are looking for a button to select just those with numbers, the attached might help.

Failing that, I can't see how the expression I said wouldn't give you the result in the listbox you are after.

Maybe if you could knock up an example (or adjust mine a bit), it would be easier to understand you end requirement

thanks

Joe

[evansabres]

This was what I was looking for.

Thank you!

[#10]

No problem. I should say you do have the option of adjusting those blanks to be nulls instead, which would make them drop from the listbox as default, nulls are not selectable.

I have found having nulls as actual values better though, as you may want the reverse of that question, which Names do not have an [STD ID], which is much easier to analyse when you have a selectable value instead of a null.

Just food for thought really

hope that helps

Joe