Skip to main content Skip to complementary content

Preparing the source data

Procedure

  1. Double-click the tFixedFlowInput component to open its Basic settings view.
  2. Click the [...] button next to Edit schema to open the Schema dialog box.
  3. Click the [+] button to add six columns: EmployeeID of the Integer type, EmployeeName, OrgTeam and JobTitle of the String type, OnboardDate of the Data type with the yyyy-MM-dd date pattern, and MonthSalary of the Double type.
  4. Click OK to close the dialog box and accept schema propagation to the next component.
  5. In the Mode area, select Use Inline Content (delimited file) and enter the following employee data in the Content field. 
    12000;James;Dev Team;Developer;2008-01-01;15000.01
12001;Jimmy;Dev Team;Developer;2008-11-22;13000.11
12002;Herbert;QA Team;Tester;2008-05-12;12000.22
12003;Harry;Doc Team;Technical Writer;2009-03-10;12000.33
12004;Ronald;QA Team;Tester;2009-06-20;12500.44
12005;Mike;Dev Team;Developer;2009-10-15;14000.55
12006;Jack;QA Team;Tester;2009-03-25;13500.66
12007;Thomas;Dev Team;Developer;2010-02-20;16000.77
12008;Michael;Dev Team;Developer;2010-07-15;14000.88
12009;Peter;Doc Team;Technical Writer;2011-02-10;12500.99
  6. Double-click the tFileOutputDelimited component to open its Basic settings view.
  7. In the File Name field, specify the file into which the input data will be written. In this example, it is "E:/employee.csv".
  8. Click Advanced settings to open the Advanced settings view of the tFileOutputDelimited component.
  9. Select the Advanced separator (for numbers) check box and in the Thousands separator and Decimal separator fields displayed, specify the separators for thousands and decimal. In this example, the default values "," and "." are used.

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 – let us know how we can improve!

Leave your feedback here