Create duplicate records on the output data

[MandyL]

Hi,

There are two data sources, one is target table and the other is user table. The target table should be set as main table. I'm used the "Find Replace" tool, the target set as Find table and user table set as Replace table. However, the duplicate record can't display.

May I know is there any function can display as output below? (The target table should set as main table)Thanks!

Target Table			User Table
Customer Key	Target		Customer Key	User
1000	1000		1000	John
1001	5000		1001	Keith
1002	10000		1001	Monika
			1002	Ben

Output
Customer Key	Target	User
1000	1000	John
1001	5000	Keith
1001	5000	Monika
1002	10000	Ben

Best regards,

Mandy

[Jonathan-Sherman · Accepted solution]

Hi @MandyL,

Rather than using the find and replace tool you may be better simply joining the two tables together on the Customer Key field.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan