Skip to main content Skip to complementary content

Configuring the output components and viewing the Job execution result

Procedure

  1. Double-click the first tFileOutputDelimited component to display its Basic settings.
    Screenshot of the component basic settings.
  2. In the File Name field, specify the path and name of the file to write with the valid data.
  3. Define the row and field separators in the corresponding fields.
  4. Select the Include Header check box to include column headers in the output data.
  5. Repeat the steps above on the second tFileOutputDelimited component to configure the output of the rejected data.
    Screenshot of the component basic settings.
  6. Double-click the tJava component to display its Basic settings.
    Screenshot of the component basic settings.
  7. In the Code field, type in the code that will display the number of updated, inserted, and rejected lines processed: 
    System.out.println("Valid data: "+((Integer)globalMap.get("tFileOutputDelimited_1_NB_LINE"))+"\nRejected
data: "+((Integer)globalMap.get("tFileOutputDelimited_2_NB_LINE")));
  8. Save your Job and press F6 to execute it.
    Screenshot of the console after successfully running the Job.

Results

Valid data is outputted in the first delimited file and rejects to the second, and the console displays the number of valid lines and the number of rejects processed in the Job.

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!

Leave your feedback here