LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Filter where not whole number

    Employee
    Posted 07-10-2018 12:42

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jchartrand

    Is there a way that I can split my data where it is not a whole number?

    I'm currently getting creative, but would like to know if there is an easier way.

    Currently I am using ceiling to get the highest integer, then dividing that back by the original value and splitting where the result is > 1.

    Example
    11.46
    12.0
    12.06
    12.08
    12.39
    13.0
    14.0

    Output 1
    12.0
    13.0
    14.0

    Output 2
    11.46
    12.06
    12.08
    12.39

    Thanks,
    J


  • 2.  RE: Filter where not whole number

    Employee
    Posted 07-10-2018 13:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    This should work:

    node:Split
bretype:core::Split
editor:sortkey=5b45118406ce2815
input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
output:@40fd2c7420761db6/=
output:@456df11556bd6bcf/=
prop:PredicateExpr=<<EOX
'Numbers'.long() == 'Numbers'
EOX
editor:XY=250,210
end:Split

node:Static_Data
bretype:core::Static Data
editor:sortkey=5b45106b728d6c71
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
Numbers:double
11.46
12.0
12.06
12.08
12.39
13.0
14.0
EOX
editor:XY=130,210
end:Static_Data