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

[SiddeshDhruva]

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
Project	ID	Portfolio	Logic Output
AB1234	AB1258	68397	68407
AB1235	AB1259	68398
AB1236	AB1243	68399
AB1237	AB1239	68400
AB1238	AB1253	68401
AB1239	AB1254	68402	68400
AB1240	AB1255	68403
AB1241	AB1256	68404
AB1242	AB1257	68405
AB1243	AB1258	68406	68399
AB1244	AB1234	68407
AB1245		68408
AB1246		68409
AB1247		68410
AB1248	AB1239	68411
AB1249		68412	68416
AB1250		68413	68417
AB1251		68414	68418
AB1252		68415
AB1253	AB1249	68416	68401
AB1254	AB1250	68417	68402
AB1255	AB1251	68418	68403
AB1256	AB1257	68419	68404
AB1257	AB1258	68420	68405
AB1258	AB1259	68421	68397

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!

[binuacs]

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

[abacon]

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

[AlteryxTrev]

@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