ETL::Pipeline::Input::File::Table - Sequential input in rows and columns
# In the input source... use Moose; with 'ETL::Pipeline::Input'; with 'ETL::Pipeline::Input::File'; with 'ETL::Pipeline::Input::File::Table'; ...
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.
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 );
ETL::Pipeline, ETL::Pipeline::Input, ETL::Pipeline::Input::File
Robert Wohlfarth <robert.j.wohlfarth@vumc.org>
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.
To install ETL::Pipeline, copy and paste the appropriate command in to your terminal.
cpanm
cpanm ETL::Pipeline
CPAN shell
perl -MCPAN -e shell install ETL::Pipeline
For more information on module installation, please visit the detailed CPAN module installation guide.