If Else Mapping File

[CharlesCapuno07]

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

[vsoni]

This post: https://community.alteryx.com/t5/Engine-Works/For-the-Love-of-Formulas/ba-p/20089 may help you get this created

[atcodedog05]

Hi @CharlesCapuno07 

If the formula is defined properly in excel below is how you can do it.

Hope this helps : )

[CharlesCapuno07]

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.

[CharlesCapuno07]

---

@atcodedog05 wrote:

Hi @CharlesCapuno07 

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 · Accepted solution]

Hi @CharlesCapuno07 

The issue is a formula issue please make all formulas created and coming out of formula tool are valid and don't have error.