Alteryx Designer Desktop Discussions

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

Vlookup/ replace multiple fields

Apwc
5 - Atom

Is there a way to Vlookup/ replace multiple fields, have been doing "Find Replace" but there are over 50 fields, if there is a single tool to perform that function instead of 50 "Find replace" that would be awesome! Thank you.

 

NYWICADEHI
111AAAAAAAAAAAA
222AAAAAA999AAA
AAA333AAAAAA666
888777444555AAA
AAAAAAAAAAAAAAA

 

111Yes
222No
333No
444Yes
555No
666Yes
777No
888Yes
999No

 

Result

NYWICADEHI
YesAAAAAAAAAAAA
NoAAAAAANoAAA
AAANoAAAAAAYes
YesNoYesNoAAA
AAAAAAAAAAAAAAA
5 REPLIES 5
binuacs
20 - Arcturus

@Apwc one way of doing this with the find and replace tool

image.png

Apwc
5 - Atom

Thank you! That is very helpful! That solve my problem, but just curious, what if I only need to replace it for NY, CA and HI? Is there a way to do that as well? 

bgreedy
7 - Meteor

Hi,

 

One option is to transpose the data to consolidate all the values into a single column, find and replace, then cross-tab to revert the table back 

 

Example workflow attatched

binuacs
20 - Arcturus

@Apwc use the dynamic select tool

image.png

Apwc
5 - Atom

Thank you! That is super helpful! 

Labels