If target row contains “xd” then update using source column1 if not update using source column2
Exactly. After the seek step is there you can add a target variable referencing that step. Then use the target variable in the data formula.
so just add a plain seek step in the beginning and then reference it in the update step?
There are several ways to accomplish this. Seek step with a target variable and IF statement in the formula should be the most straight forward.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer