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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Replicate a row many times on the basis of the value of a column in the row

Dear all, i need a way to replicate the rows of a table many times on the basis of the value of a column in the same rows.

To make an example:

 

row1 : aaa     bbb   ccc   10

row2: abc      def    ghi     5

 

i want to replicate the row1 10 times and the row2  5 times.

 

the result will be:

 

aaa     bbb   ccc   10

aaa     bbb   ccc   10

aaa     bbb   ccc   10

aaa     bbb   ccc   10

aaa     bbb   ccc   10

....

abc      def    ghi     5

abc      def    ghi     5

abc      def    ghi     5

abc      def    ghi     5

...

 

is there a way to solve that issue?

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hello,

Please have a look at tRowGenerator component. It can generate as many rows and fields as are required using random values taken from a list.

For more information, please have a look at this component reference about:TalendHelpCenter:tRowGenerator.

Best regards

Sabrina

 

Anonymous
Not applicable
Author

as per the solution suggested , it will generate all random values given inside the trowgenerator component

 

Could you explain in details to take the input given and print output as expected