ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find and Replace or Other tool

Drexler
6 - Meteoroid

Good day, newbie here

 

I have 2 files, 1 file has columns A and B while file 2 has column A only. Both data of columns  A (file 1 and 2) are the same. I need to transfer the equivalent data of file 1 column B to file 2 column B if both columns A for 2 files are match. What's the best solution/tool for this scenario

 

See sample data below. Thank you Everyone

 

1000014206.jpg

1 REPLY 1
joelmiller66
9 - Comet

@Drexler I believe you can use a Join Tool or a Find & Replace Tool. Attached are sample workflows.

sample2.pngsample1.png

Labels
Top Solution Authors