Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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/
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
See attached if that helps
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
Dear Evan,
Kindly find attached document.
Kind regards,
Ishfaque Ahmed
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
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
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
This was what I was looking for.
Thank you!
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