Match Cell Value in the Next entire Column and Copy Corresponding Output

Question

Hi Alteryx Community,

I'm working with a single dataset in Alteryx and need to match a specific cell value with an entire column. If a match is found, I want to return the corresponding value from another column within the same dataset.

Here's a brief overview of my setup:

* I have a column with a specific cell value that I want to match against another column in the same dataset.
* Upon finding a match, I need to extract the corresponding value from a different column in the same dataset.

below is the example data:

Input file ProjectIDPortfolioLogic OutputAB1234AB12586839768407AB1235AB125968398 AB1236AB124368399 AB1237AB123968400 AB1238AB125368401 AB1239AB12546840268400AB1240AB125568403 AB1241AB125668404 AB1242AB125768405 AB1243AB12586840668399AB1244AB123468407 AB1245 68408 AB1246 68409 AB1247 68410 AB1248AB123968411 AB1249 6841268416AB1250 6841368417AB1251 6841468418AB1252 68415 AB1253AB12496841668401AB1254AB12506841768402AB1255AB12516841868403AB1256AB12576841968404AB1257AB12586842068405AB1258AB12596842168397

Could anyone guide me on how to accomplish this using Alteryx tools? Is there a specific tool or formula configuration that would be best suited for this task?

Thank you in advance for your help!

AlteryxTrev · Answer

@SiddeshDhruva What you are asking is very possible! All you need to do here is to send your data into two different stream and then join them back together on Project and ID to return Portfolio for any matches. You will need to be mindful about cardinality so you don't create duplicate rows. Further, I always like to reorder the data such that it ends the same way it starts. If it is helpful, I've created a short video illustration how you can go about doing this: https://youtu.be/OZZnNGhH8IE

abacon · Answer

I am confused as to what you are looking to do fully but from what I see, a Join tool will get you mostly if not all the way there. Just join the datasets on the matching columns, and ensure the correct fields pass out the J output using the select options within the Join

Bacon

binu_acs · Answer

@SiddeshDhruva what is the logic for getting the "Logic Output" column here?