Seeking somehting similar to a VLOOKUP function

Question

Hello all,

I am very new to Alteryz. I am attempting to accomplish the attached workflow but for multiple different columns all in one workflow. Each column's result needs to be independent of each other. Essentially, what I am looking to accomplish is that anytime a column (say column B)  has a specific word (say "Yes") with an associated number (say #122) in column A, then anytime that associated number (#122) in column A appears again in the dataset, the value for column B in that row brings back "Yes".

I cannot list out each specific number that needs to be changed because my actual dataset is too large.

The attached workflow accomplishes this scenario for just one column, but I need to add other columns that will reference to column A as well.

Any help is appreciated!

2023-11-15_11-22_Filter Update (1).yxmd

CoG · Answer

I also made a macro that does the same thing my workflow does!

2023-11-15_11-22_Filter Update (1).yxzp

FilterUpdate.yxmc

SPetrie · Answer

I believe this will work. I may be overcomplicating it a bit, but it made sense to me while I was making it.  :)

I use dynamic replaces to dynamically create test formulas and then use those in another replace to then update the values.

You just need to add new column names and test values to the setup file when new ones occur.

DoubleDynamic.yxmd

CoG · Answer

There are several ways of doing this. You can repeat your own method and just swap out which column and value you are looking for. I have put together another solution with Multi-Row tool and sorts:

2023-11-15_11-22_Filter Update (1).yxmd