topic Re: Generate Multiple Rows in Talend Studio

Generate Multiple Rows

Anonymous — Sat, 16 Nov 2024 13:11:31 GMT

Hi,
I have data in excel like below columns e.g.
A1 B1 C1 1 11
A2 B2 C2 2 22
Need to transfor into following pattern.
A1 B1 C1 1
A1 B1 C1 2
A1 B1 C1 11
A1 B1 C1 22
A2 B2 C2 1
A2 B2 C2 2
A2 B2 C2 11
A2 B2 C2 22
I know I can read data from 1st to 3rd column and then read 4th to 5th column but my issue is then how to generate rows by multiplying rows with columns.
will appreciate any suggestion.
Thanks!

Re: Generate Multiple Rows

alevy — Fri, 03 Dec 2010 01:04:41 GMT

There are many posts on the forum about creating multiple rows out of each input row, https://community.talend.com/t5/Design-and-Development/Convert-one-row-fieldset-to-multiple-rows/td-p/65593.

Re: Generate Multiple Rows

Anonymous — Wed, 15 Dec 2010 15:36:12 GMT

phew! finally got this...here is a tUnpivot plugin in order to achieve the format.