Performing Vlookup or Find/Replace to show multiple possible matches

[dpakapd]

I have 2 sets of data available, a sample of which I am showing below.

Dataset A:

Part Number	Product Code
1A-45XD	1234
1D2B3C	4567

Dataset B:

Part Number	Master Prod Code
1A-45XD	1234
1A-45XD	0408
1D2B3C	4567
1D2B3C	0816

How can I perform a Vlookup or Find/Replace such that I get an output as shown below:

Part Number	Product Code	Master Prod Code
1A-45XD	1234	1234
1A-45XD	1234	0408
1D2B3C	4567	4567
1D2B3C	4567	0816

I tried with the standard 'Find Replace' tool in Alteryx but it catches only the first match for each part number.

I have close to 60,000 rows of distinct part numbers. So setting a filter for each part number does not seem feasible.

Thanks,

[AngelosPachis · Accepted solution]

Hi @dpakapd ,

If you make sure that all part numbers in Dataset A are unique (i.e. they only appear once) you can use a join tool to get the output you're after

[dpakapd]

Thanks @AngelosPachis.

I also tried by changing the order of the Find-Replace, i.e. swapping the nodes that go to Find and to replace and I was able to get a similar output.

I will try yours in my full dataset.

Thanks again!