We have an excel sent by the users that need to be processed that will contain the following data:
Variable Name | Condition 1 | Operator | Condition 2 | True Statement | False Statement
MyVariable1 | A | = | B | They are the same | They are not the same
Myvariable2 | A | <> | B | The are different | They are not different
MyVariable3 | 1 | > | 2 | Bigger | Smaller
MyVariable4 | 1 | = | “” | Is Empty | Is not empty
The number of rows is undefined, we need to replace in a document “MyVariable1”, “MyVariable2”, “MyVariable3”… with the true statement or false statement depending if the condition is true or false (based on the 3 columns “Condition 1 / Operator / Condition 2”.
We managed to do that by assigning every element to a variable but it forced us to have a static table. How is it possible to implement it using a unknown numbers of row, unknown operator, and unknown variable name?
Thank you for your help,