Select the tFileInputDelimited component to
define its properties.
In the Basic settings tab, click
the [...] button next to the File name/Stream field then browse to the location on
your file system where the input Excel file is stored, or enter the path manually
between double quotes. For this example, use
<PATH_TO_WORKSPACE>/<PROJECT_NAME>/Sample
Data/CSV/PurchaseOrderPayPal/PayPalPO.csv.
Select the CSV options check box.
Change the Field Separator to a
comma, between double quotes (",").
Change the value of Header to
1.
Click the [...] button next to Edit schema to define the schema.
Add three columns and rename them txn_id,
payment_date and first_name (which
correspond to the names of the first three columns in the input file, and is
sufficient for the purposes of this example), and then click OK.
Leave all the other parameters unchanged.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
