Advanced Find & Replace

Hello all. I have two data files (excel files) that I need to do a find a replace on. The first file (original file) has 2,500+ rows of data and 60+ columns of data. The second file (replacement file) has 45 rows of data and 6 columns of data. There is a column in both data files that act as a "key".

What I'm trying to do is end up with a file with the same number of columns and rows as the first file, but use the second file to replace values in the first file if they are populated in the second file. Attached is a screen shot of what the second file looks like without any P.I.

Thanks!

Alteryx SS.PNG

Join

Accepted answers

HomesickSurfer

Hi @rclover11

Keep it lean and simple with the less known 'Append' functionality within the 'Find Replace' tool and some fields' values swapping formulas.

Note You may benefit from data cleansing both source and target datasets to ensure matching.

All comments

Raj

@rclover11 Please share some sample input and Expected Output data.
with this limited information it is difficult to help you with proper steps involved.

rclover11

I have attached a generic example of what I'm trying to achieve. "Alteryx Input1 SS" is the first input file that I want to change certain values in. "Alteryx Input2 SS" is the file that has the updated values. "Alteryx Output SS" has the expected output. As you can see, there are more rows and columns in the first input file and I don't want any values to change unless they are present in the second input file.

Alteryx Input2 SS.PNG

Alteryx Input1 SS.PNG

Alteryx Output SS.PNG

binu_acs

@rclover11 One way of doing this

Replace_290224.yxmd

rclover11

I'll try to leverage what you have. My output file needs to have all the columns from the original file and not just the columns/fields that were changed.