Duplicate records in specific format

[Vishu1]

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 · Accepted solution]

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]

@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. 

map.PNG
splitrows.PNG

[Vishu1]

@TRF Thanks, tSplitRow worked for me.

[TRF]

Great!
You're welcome