Matching cell data across columns and replace

Hi, I'm very new to Alteryx and trying to write a workflow that will match test data across two table columns, and if they match, replace the data in one column with data from a third column. Is this even possible?

I essentially have an index of data that I've sorted and categorized, and I want to replace the old data with the new by matching old to old and replacing with corresponding new. Does this make sense? Would appreciate any help.

Connectors

Help

Join

Accepted answers

binu_acs

@mjflynn03 Use the join tool - Join the matching columns, select the column you want in your output

All comments

binu_acs

@mjflynn03 Use the join tool - Join the matching columns, select the column you want in your output

mjflynn03

That doesn't work. The index is a unique list of the data in the original column which has repetitions. There's a new value for each unique value, so the matching columns are different lengths. Is there a workflow I can use that goes cell by cell and matches the data to test if it should be replaced?

lbardoe

is the data set very large. Could you use a transpose columns to rows, then use a Find and Replace tool on the single column and then use a transpose rows to columns to put the data back into order. You will need to add a Record ID field so that the records dont get concatenated.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703