topic Create rows from columns in Talend Studio

Create rows from columns

Anonymous — Wed, 11 Oct 2017 15:13:54 GMT

Hi,

I want to get rows from some columns. In my TOS DI is nothing like unpivot.

My data is stored in an excel spreadsheet and the structure looks like this.

order_nr | name | ali_1 | ali_2 | ali_3 | ali_4 | ali_4

-------------------------------------------------------------------

1234 | test | 10 | 100 | 200

5678 | test-2 | 100 | 200 | 300 | 400

The output should be the following

1234-1 | test | 10

1234-2 | test | 100

1234-3 | test | 200

5678-1 | test-2| 100

5678-2 | test-2| 200

5678-3 | test-2| 300

5678-4 | test-2| 400

How can I achive this?

Best regards

Anonymous — Wed, 11 Oct 2017 15:58:58 GMT

tsplitsrow would help in this case.

Anonymous — Wed, 11 Oct 2017 16:18:17 GMT

You can do this with a combination of tSplitRow and tFilterRow as follows:

The tSplitRow has an output schema of just the three fields:

And is configured to produce a line for each of the value columns:

You then just filter out the ones with empty values using tFilterRow: