Configuring the components

Procedure

Double-click tS3Get to open its Basic settings view.
1. Enter your access key and secret key in the corresponding fields.
2. Enter the name of the S3 bucket where the CSV file resides in the Bucket field.
3. Enter the name of the CSV file in the Key field.
4. Enter the path and the filename which you want to save the downloaded file in the File field.
5. Leave other options as they are.
Information noteNote: All the parameters mentioned above need to be given in double quotation marks.
Double-click tFileInputDelimited to open its Basic settings view.
1. Click the […] button next to Edit schema and add four columns in the schema editor: ID, type Integer; Name, type String; Address, type String, and RegTime, type Date and format of dd/MM/yyyy.
2. Click Yes when prompted to propagated the changes.
  This propagates the schema to the tLogRow component.
3. Enter the path and the filename of the downloaded file in the File name/Stream field.
  The path and the filename provided in this filed need to be the same as those provided in substep d in the previous step.
4. Leave other options as they are.
Double-click tLogRow to open its Basic settings view.

Select Table (print values in cells of a table) for a better display of the results.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!