Procedure
-
Double-click tS3Get to
open its Basic settings view.
- Enter your access key and secret key in the corresponding fields.
- Enter the name of the S3 bucket where the CSV file resides in the Bucket field.
- Enter the name of the CSV file in the Key field.
- Enter the path and the filename which you want to save the downloaded file in the File field.
- Leave other options as they are.
Note: All the parameters mentioned above need to be given in double quotation marks. -
Double-click tFileInputDelimited to open its
Basic settings view.
- 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.
-
Click Yes when prompted to propagated the changes.
This propagates the schema to the tLogRow component.
-
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.
- 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.