input

Get value from input dataset

The simplest method to take a column from CSV is this:

date.yaml

version: 1
columns:
  date: "Transaction Date"

input.csv

Transaction Date
06/05/2020

output.csv

date
06/05/2020

This is not extensible however: you cannot add more transformations beneath that string. More flexible, and recommended, is this:

version: 1
columns:
  date:
    - input: "Transaction Date"
    # you can add more transformations down here :)

But sometimes you might have a number of slightly different CSV datasets where the same column is named differently. ysv supports that:

version: 1
columns:
  date:
    - input:
      - "Transaction Date"
      - "Event Date"
      - "Date"
    # you can add more transformations down here :)

ysv will search for each of the names you specified in the headers of the input dataset. The first header found is going to be used.

Regardless of the form of input transformation, - if no headers match, the column will be empty.