Check if values in one column exist in another and update a third.

DMDingo

I am new to Alteryx and cannot find a solution for this. We have three columns of data:

Column A is the ID
Column B is Parent's ID (like hierarchy)

Column C is the Type

For each row, we need to lookup if Column A exist anywhere in Column B, and overwrite Column C with a new value if this is True. If not, no change.

Here is an example:

Row	A	B	C
1	215		Associate
2	122	215	Associate
3	554		Manager

For this example, because "215" is showing in B, we would want the Value C in Row 1 to update to "Manager". All other values in C would need to stay the same.

Thank you!

jdunkerley79

Based on what you described:

 

1. Self join the data to itself (A to

2. L output is stuff not preset, J output is stuff present

3. Use a formula tool to manipulate column C

4. Use a union tool to put it back together

Sample attached but if you can post some fake data easier to get closer

Update If Present.yxmd