topic Re: Duplicate records in specific format in Talend Studio

Duplicate records in specific format

Vishu1 — Sun, 04 Nov 2018 11:28:44 GMT

Hello,

I have below requirement. I am trying to save result from one table to another table.

Source:

Id,Name,HomePhone,MobilePhone

1,john,111111111,222222222

2,Mike,,444444444

Target:

Id,Name,Phone

1,john,111111111

1,john,222222222

2,mike,444444444

How can I achieve this in Talend, I am using subscription version of Talend 7.

Thanks,

TRF — Sun, 04 Nov 2018 11:51:21 GMT

Use tSplitRow to create a row for each phone number with the same Id.
Then tFilterRow to reject null phone numbers for these new rows.
Got it?

Vishu1 — Sun, 04 Nov 2018 11:56:45 GMT

@TRF Thanks, I will try your solution.

I tried below way which is giving the expected output, but I think I am using more component and which can be done using fewer.

Vishu1 — Sun, 04 Nov 2018 12:06:56 GMT

@TRF Thanks, tSplitRow worked for me.

TRF — Sun, 04 Nov 2018 12:34:03 GMT

Great!
You're welcome