topic Re: one record to be split into two records in Talend Studio

one record to be split into two records

bhagyarekha — Wed, 24 Apr 2019 11:50:36 GMT

hi all

i have one record with following data

input

ID CODE PRICE

123 C2345 500

now i need to make two records from it

c2345==2345:5678 (this code am having in my sheet i need to compare the sheet and generate it)

output

ID CODE PRICE

123 2345 499
123 5678 1

Thanks&regards

bhagyarekha

Re: one record to be split into two records

akumar2301 — Wed, 24 Apr 2019 12:23:43 GMT

How did you split the price column ?

Re: one record to be split into two records

bhagyarekha — Wed, 24 Apr 2019 12:26:36 GMT

That is main price minus one

Re: one record to be split into two records

akumar2301 — Wed, 24 Apr 2019 12:48:47 GMT

Assuming that , you have another sheet with data like

CODE MAPEDCODE

C2345 2345:5678

in tMap , do a join between two sheet,so that output of tmap will be

ID CODE PRICE

123 2345:5678 500

the use tNornamise - Code

ID CODE PRICE

123 2345 500

123 5678 500

Now on tJavaRow ,

output_row.ID=input_row.ID

output_row.CODE=input_row.CODE

output_row.PRICE = input_row.PRICE - Numeric.sequence(input_row.ID,0,1)

Re: one record to be split into two records

bhagyarekha — Wed, 24 Apr 2019 13:03:45 GMT

Ya I have tried up to t normalize now I will add tjavarow and will update you.

Thanks for your time abhisheik

Re: one record to be split into two records

bhagyarekha — Wed, 24 Apr 2019 13:22:17 GMT

Here am getting output in price column as 499 in both records.
I want 499 in one record and 1 in one record

Re: one record to be split into two records

akumar2301 — Wed, 24 Apr 2019 14:03:43 GMT

sorry try this

Integer seq = Numeric.sequence(input_row.ID,1,1) ;

output_row.ID=input_row.ID;

output_row.CODE=input_row.CODE;

output_row.PRICE = (seq == 1)?input_row.PRICE - seq : seq - 1;

Re: one record to be split into two records

Anonymous — Wed, 24 Apr 2019 14:19:02 GMT

Hi,

Could you please try below method?

The component details are as below.

Please maintain the order of the tMaps as shown in picture. Instead of hard coding, you can even convert the value 1 with a context variable if the discount is different for each run.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: one record to be split into two records

Anonymous — Fri, 26 Apr 2019 05:08:41 GMT

@bhagyarekha

Hope you were able to resolve your issue by one of the above methods.

If you do not have any outstanding queries, could you please mark the topic as resolved by marking the posts which helped you?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂