Advanced Find & Replace

[rclover11]

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!

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

[binuacs]

@rclover11 One way of doing this

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

[Qiu]

@rclover11 

For multiple columns, we can use the combination of Transpose and Cross Tab.

[rclover11]

Thank you! This looks like it gets me to where I need to be. Can you share the Alteryx flow by chance?

[Qiu]

@rclover11 
I thought I did  My bad😂

[HomesickSurfer · Accepted solution]

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.