I have changed variable names and excluded quite a bit of logic in the workflow because some may be sensitive information but it should be enough to describe my problem. I need to take existing logic for a field that is currently created using an if statement and create a lookup table where I can instead map the created field by joining on the two fields used in the if statement. I have included a workflow with the logic and an example for what I am looking to do. I just can't figure out how I can take the various permutations of the if statement and quickly create a lookup table. If you can help me I will greatly appreciate it.
Hey @Rwebber1991,
This join applies the same logic as your formula:
It joins on both of your fields. If you have any questions make sure to ask :)
HTH,
Ira