NAME

ETL::Pipeline::Input::File::Table - Sequential input in rows and columns

SYNOPSIS

# In the input source...
use Moose;
with 'ETL::Pipeline::Input';
with 'ETL::Pipeline::Input::File';
with 'ETL::Pipeline::Input::File::Table';
...

DESCRIPTION

CSV (comma separated values) or Excel spreadsheet files represent data in a table structure. Each row is a record. Each column an individual field. This role provides some attributes common for this type of data. That way you don't have to reinvent the wheel every time.

METHODS & ATTRIBUTES

Arguments for "input" in ETL::Pipeline

no_column_names

Tabular data usually has field names in the very first row. This makes it easier for a human being to read. Sometimes, though, there are no field names. The data starts on the very first row.

Set no_column_name to true for these cases. Otherwise, the input source will load your first row of data as field names.

$etl->input( 'Excel', no_column_names => 1 );

SEE ALSO

ETL::Pipeline, ETL::Pipeline::Input, ETL::Pipeline::Input::File

AUTHOR

Robert Wohlfarth <robert.j.wohlfarth@vumc.org>

LICENSE

Copyright 2021 (c) Vanderbilt University Medical Center

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.