Filter where not whole number

Follow

Infogix Support

• July 10, 2018 19:42

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

0

• 

  Infogix Support

  • July 10, 2018 20:09

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.