Contents

# in:
#   type: random
#   rows: 100
#   schema:
#     id: primary_key
#     name: string
#     score: integer
in:
  type: file
  path_prefix: example/example.csv
  parser:
    type: csv
    charset: UTF-8
    newline: CRLF
    null_string: 'NULL'
    skip_header_lines: 1
    comment_line_marker: '#'
    columns:
      - {name: time,  type: timestamp, format: "%Y-%m-%d"}
      - {name: foo,   type: string}
      - {name: bar,   type: string}
      - {name: flag,  type: boolean}
      - {name: id,    type: long}
      - {name: name,  type: string}
      - {name: score, type: double}
filters:
  - type: row
    conditions:
      - {column: flag,  operator: ==,  argument: true}
      - {column: foo,   operator: "IS NULL"}
      - {column: id,    operator: ==,  argument: 97}
      - {column: name,  operator: ==,  argument: "xxxx", not: true}
      - {column: score, operator: ">", argument: 2000}
      - {column: score, operator: "<", argument: 6000}
      - {column: time,  operator: ==,  argument: "2015-07-13", format: "%Y-%m-%d"}
      # - {column: missing, operator: "==", argument: 6000}
out:
  type: stdout

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
embulk-filter-row-0.2.1	example/and.yml
embulk-filter-row-0.2.0	example/and.yml