Sha256: 4ed827c5a6056edcfedf7859395f3e32c413d50e65528fcc23b74465f7ddfad1

Contents?: true

Size: 579 Bytes

Versions: 4

Compression:

Stored size: 579 Bytes

Contents

source :in, {
  :file => 'data/delimited.txt',
  :parser => {
    :name => :csv
  }
}, 
[ 
  :first_name,
  :last_name,
  :ssn,
  :age,
  :sex
]

#transform :age, :type, :type => :number
transform :ssn, :sha1
transform(:ssn){ |n, v, row| v[0,24] }
transform :sex, :decode, {:decode_table_path => 'data/decode.txt'}

destination :out, {
  :type => :excel,
  :file => 'output/delimited_excel.xls'
},
{
  :order => [:id, :first_name, :last_name, :ssn, :age, :sex, :test, :calc_test],
  :virtual => {
    :id => :surrogate_key,
    :test => "test!",
    :calc_test => Time.now
  },
}

Version data entries

4 entries across 4 versions & 3 rubygems

Version Path
activewarehouse-etl-1.0.0 test/delimited_excel.ctl
activewarehouse-etl-1.0.0.rc1 test/delimited_excel.ctl
etl-0.9.5.rc1 spec/fixtures/delimited_excel.ctl
activewarehouse-etl-sgonyea-0.9.6 test/delimited_excel.ctl