Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2010-12-02 04:27 PM

Generate Multiple Rows

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!
Labels (2)
Labels
150 Views
0 Likes
2 Replies
alevy
Specialist
Specialist
‎2010-12-02 08:04 PM

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-....
150 Views
0 Likes
Anonymous
Not applicable
‎2010-12-15 10:36 AM
Author

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