How to get Numbers from my list box

[madhubabum]

Hi All

I have the following list box.....

DepartmentId:

ab_100

bc_200

st_300

100

200

300
400

Sol: I want only 100,200,300,400....

How can we achieve this.

[jonathandienst]

Use this expression in your list box:

=Aggr(If(IsNum(DepartmentId), DepartmentId), DepartmentId)

[#3]

=if(IsNum(DepartmentId),DepartmentId)

[madhubabum]

Hi Thanks to reply

But with the help of Inner Join ......I want to make changes in DataModel

[Anonymous]

In list box properties, ---> select Expression from field drop down ------> edit --------> use the below expression. and it should bring only the selected field values

=if(match(DepartmentId,'100','200','300','400'), DepartmentId)

[jonathandienst]

LOAD

     ...

     DepartmentId As AllDepartmentIds,

     If(IsNum(DepartmentId), DepartmentId) As DepartmentId,

     ...

[settu_periasamy]

Hi,

Try this in your script. (if you have only one underscore in your data)

subfield(DepartmentId,'_',2) as DepartmentId

[MarcoWedel]

another solution could be:

KeepChar(DepartmentId, '0123456789')

please elaborate on your requirements to be able to deliver correct answers.

thanks

regards

Marco

[madhubabum]

Hi SaiRamdc

Thanks to your reply

I want filter the data from "June 2003" to "may 2004" with "WHERE" condition in script level

[avinashelite]

try like this:

Load *

from

table

where monthname(datecolumn)>=monthname(makedate(2003,06) and monthname(datecolumn)<=monthname(makedate(2004,05)