Results 1 to 2 of 2

Thread: Filter where not whole number

  1. #1

    Question Filter where not whole number

    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
    Last edited by jchartrand; 07-10-2018 at 07:52 PM.

  2. #2
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    185

    Default

    This should work:

    Code:
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •