I am provided a mapping file in excel format that contains a list of "if else conditions" and can be updated every time the workflow runs. Below is a sample:
IF | AND IF | THEN | ELSE |
Field 1 = AAA | Field 2 = Test 1 | Field 4 | Field 5 |
Field 1 = BBB | Field 5 = Blank | Field 4 | - |
Field 1 = CCC | Field 3 = 111 | Field 4 | Field 5 |
Field 1 = DDD | - | Field 5 | Field 4 |
This is expected to be dynamic where output is identified from "THEN" and "ELSE" depending on the "IF" and "AND IF" columns. Like an "IF ELSE" but is file dependent.
Here's is a sample data you can use as a reference
Solved! Go to Solution.
This post: https://community.alteryx.com/t5/Engine-Works/For-the-Love-of-Formulas/ba-p/20089 may help you get this created
If the formula is defined properly in excel below is how you can do it.
Hope this helps : )
Thanks for the workflow. It seems that this can fix my problem. Can I request you to send an updated one? I'm having an error when I run the workflow (Error: Dynamic Replace (8): Parse Error at char(3): Unknown variable "Field"). I'm still not acquainted to dynamic replace so I'm not sure how to fix it.
@atcodedog05 wrote:
If the formula is defined properly in excel below is how you can do it.
Hope this helps : )
Thanks for the workflow. It seems that this can fix my problem. Can I request you to send an updated one? I'm having an error when I run the workflow (Error: Dynamic Replace (8): Parse Error at char(3): Unknown variable "Field"). I'm still not acquainted to dynamic replace so I'm not sure how to fix it.
The issue is a formula issue please make all formulas created and coming out of formula tool are valid and don't have error.