Text File Output

Output text files ..

Workshop - Text File Output

Reading files is only half the job. You also need to generate files for users and systems.

In this workshop, you build a transformation that writes a customer survey for Steel Wheels. You will build the survey from multiple streams. You will parameterize it with a runtime customer name.

What you'll do

• Read a customer name from a transformation argument
• Build header and body sections with static rows and file-driven rows
• Format text using User Defined Java Expression
• Merge streams in a predictable order with Append streams
• Write the final output with Text file output

Prerequisites: Understanding of basic transformation concepts (steps, hops, preview). Complete Text File Input first.

Estimated time: 35 minutes

---

Workshop files

Download the following files.

Keep the filenames unchanged.

Save them in your workshop folder.

25KB

tr_write_output.ktr

Open

132B

questions.txt

Open

---

Survey - Text File Output

Create a new transformation

Use any of these options to open a new transformation tab:

• Select File > New > Transformation
• Use Ctrl+N (Windows/Linux) or Cmd+N (macOS)

---

1. Get System Info

Get System Info

Use Get System Info to read a runtime argument. We will treat the argument as the customer name.

Get System Info

1. Start Pentaho Data Integration (Spoon).

Windows (PowerShell)

Set-Location C:\Pentaho\design-tools\data-integration
.\spoon.bat

macOS / Linux

1. Drag Get System Info onto the canvas.
2. Double-click the step. Configure it like this:

Get system info

1. Select OK.

2. User Defined Java Expression

3. Data Grid

4. Append streams (head)

5. Text file input (questions)

6. User Defined Java Expression (number questions)

7. Select values

8. Append streams (body)

9. Text file output

10. RUN