Flat Files

How Data Integration handles Flat files ..

Workshops

Despite being the most basic format used to store data, files are broadly used and they exist in several formats as fixed width, comma-separated values, spreadsheet, or even free format files. Pentaho Data Integration can read data from all types of files.

TXT, CSV

TXT & CSV Files

Some of the Orders data that Steel Wheels process are in a text format. In this guided demo, you will flatten the list, create capture groups, replace text, and finally format the order_value.

In this demonstration, you will format the text file input to be onboarded into a database table:

• Text File Input

• Flattener

• RegEx Evaluation

• Replace in String

• Select values

Text File Input

TXT & CSV

Steel Wheels wants to send out a survey to its customers, based on a list of questions.

In this demonstration, you will configure a text file survey:

• Get System Info

• User Defined Java Expression

• Data Grid

• Append

• Text File Output

Text File Output

Excel

XML

JSON

RSS