Merge Streams

Workshop - Merge data streams

The transformation underlines the ‘rules’ for manipulating data streams. Each data stream must have the same data stream fields / order / data type, before they can be merged.

In this workshop, you will need to add a 'description' to the data stream:

• Add constant step

Merge data streams

---

English

Second Tab

Create a new Transformation

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

• By clicking File > New > Transformation

• By using the CTRL-N hot key

1. Text File Input

Text File input

The Text File Input step is used to read data from a variety of different text-file types. The most commonly used formats include Comma Separated Values (CSV files) generated by spreadsheets and fixed width flat files.

The Text File Input step provides you with the ability to specify a list of files to read, or a list of directories with wild cards in the form of regular expressions. In addition, you can accept filenames from a previous step making filename handling more even more generic.

1. Examine both the orders.txt and description.txt.

2. Configure the Text file input steps to point to, and retrieve the data from each of the files.

2. Add Constant

3. Select Values

4. RUN