Page tree

Versions Compared

Key

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

...

Column TypeExample TransformOutputNotes
Integer/Decimal

D trans
RawWrangletrue
p03Value!((sqft < 1300) && (bath < 2) && (bed < 2.5))
Typestep
WrangleTextkeep row:!((sqft < 1300) && (bath < 2) && (bed < 2.5))
p01NameCondition
p01ValueCustom formula
p02NameType of formula
p02ValueCustom single
p03NameCondition
p04ValueKeep matching rows
p04NameAction
SearchTermFilter rows

Keep all rows for houses that do not meet any of these criteria:

  • smaller than 1300 square feet, 
  • less than 2 bathrooms, 
  • less than 2.5 bedrooms.
 
Datetime

D trans
RawWrangletrue
p03Value!(YEAR(Date) == '2016')
Typestep
WrangleTextkeep row:!(YEAR(Date) == '2016')
p01NameCondition
p01ValueCustom formula
p02NameType of formula
p02ValueCustom single
p03NameCondition
p04ValueKeep matching rows
p04NameAction
SearchTermFilter rows

Keep all rows in the dataset where the year of the Date value is not 2016. 
String

D trans
RawWrangletrue
p03Value!(status == 'Keep_It')
Typestep
WrangleTextdelete row:!(status == 'Keep_It')
p01NameCondition
p01ValueCustom formula
p02NameType of formula
p02ValueCustom single
p03NameCondition
p04ValueDelete matching rows
p04NameAction
SearchTermFilter rows

Delete all rows in which the value of the status column is not Keep_It.

 

...

Noprint

See Also

Content by Label
showLabelsfalse
showSpacefalse
sorttitle
cqllabel = "logical" and space = currentSpace()