Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411


Column TypeExample TransformOutputNotes
D code

derive value:(MySource < 5)

  • true for all values in MySource that are less than 5.
  • Otherwise, false. 
D code

keep row:(MySource <= 2.5)

Retains all rows in the dataset where the value in the MySource column is less than or equal to 2.5. 
D code

keep row:(Date <= DATE(2009,12,31))

Retains all rows whose Date column value is less than or equal to 12/31/2009.You can also use the DATEDIF function to generate the number of days difference between two date values. Then, you can compare this difference to another value. See DATEDIF Function.
String (and all other data types)
D code

derive value:(LEN(MySource) < 5))

  • true for any string value in the MySource column whose length is less than 5 characters.
  • Otherwise, false
  • See LEN Function.
  • For comparison purposes, all data types not previously listed in this table behave like strings.
  • Since strings are non-numeric value, a function must be applied to string data to render a comparison.