Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multiple rows from one rows

Hello everyone, i'm trying to create a job in talend.

I have a file that for each row i memorize information inside an array. When i arrive on a row that satisfy a specific requirement i have to slide the array, and create a row for each index. I'm developing this logics usign a tjavaflex. Is there a way to slide the array and using the tjavaflex and create multiple rows dinamically

Labels (4)
6 Replies
Anonymous
Not applicable
Author

Hi

Can you please give an example to explain your requirement? It is helpful for us to understand the question and give you more accurate answer.

Regards

Shong

Anonymous
Not applicable
Author

i have this array 1 2 3 4 5 and for each elements i want to generate new rows.

For this example i will have these rows:

5 4

5 3

5 2

5 1

 

Anonymous
Not applicable
Author

Hi
Convert the array to a string, and then normalize the row to multiple rows using tNormalize component.

Regards
Shong
Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

So i put all the data of the array inside a string using ",". Tnormalize will generate multiple row automatically?

@rhall thank you for the answer i'll check your solution too

Anonymous
Not applicable
Author

Yes, take a look at the component documentation of tNormalize, let me know if you have any troubles or questions to use this component.