Four Stars

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

  • Big Data
  • Data Integration
6 REPLIES
Community Manager

Re: multiple rows from one rows

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

----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: multiple rows from one rows

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

 

Community Manager

Re: multiple rows from one rows

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

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Ten Stars

Re: multiple rows from one rows

Four Stars

Re: multiple rows from one rows

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

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

Community Manager

Re: multiple rows from one rows

Yes, take a look at the component documentation of tNormalize, let me know if you have any troubles or questions to use this component.
----------------------------------------------------------
Talend | Data Agility for Modern Business