topic Re: multiple rows from one rows in Talend Studio

multiple rows from one rows

Anonymous — Sat, 16 Nov 2024 09:46:11 GMT

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

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 08:37:27 GMT

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

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 08:52:28 GMT

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

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 09:19:12 GMT

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

Regards
Shong

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 09:46:59 GMT

Maybe this tutorial might help.....

https://www.rilhia.com/quicktips/quick-tip-row-multiplication

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 10:41:12 GMT

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

Re: multiple rows from one rows

Anonymous — Wed, 17 May 2017 10:56:48 GMT

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