Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Reverse Find And Replace?

whollycow
5 - Atom

Hi, 

 

So the Find and Replace function allows you to check if the value is Data A in inside a column in Data B and then allows you to append a new column in Data B. How do I add the column in Data A instead? 

 

If the value in Data A is found in a column in Data B, I want it to return a value from Data B into Data A. Please help! 

 

Data A

 

whollycow_3-1592006001933.png

 

 

Data B

 

whollycow_2-1592005968283.png

 

 

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora

Hi @whollycow, would an approach like this apply to your larger dataset? Appending the two datasets is an inefficient approach, but if your data isn't large enough this might get you to your destination.

AbhilashR_0-1592013314028.png

I hope this helps.

DavidP
17 - Castor
17 - Castor

How about using Text to Rows on Product SKU so that every row just contains a single value and then use Find Replace as normal?

Labels