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: IFAND IFTHENELSEField 1 = AAAField 2 = Test 1Field 4Field 5Field 1 = BBBField 5 = BlankField 4-Field 1 = CCCField 3 = 111Field 4Field 5Field 1 = DDD-Field 5Field 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 Sample.xlsx

If Else Mapping File

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.