Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:either [2021/05/23 21:40] – craigt | transformations:either [2021/07/17 15:14] (current) – craigt |
---|
\\ | \\ |
=====Use cases===== | =====Use cases===== |
* "If-then" types of workflows. In this scenario, the workflow should be organized in a way that makes empty either one table (when a condition is fulfilled) or another (when the condition is NOT fulfilled). Then //Either table// is used to pick a non-empty result dataset. Since both tables can have different sets of actions, it allows for applying different action logic depending on the condition. | * "If-then" types of workflows. In this scenario, the workflow should be organized in a way that makes empty either one table (when a condition is fulfilled) or another (when the condition is NOT fulfilled). Then //Either table// is used to pick a non-empty result dataset. Since both tables can have different sets of actions, it allows for applying different action logic depending on the condition. |
* Insertion of arbitrary datasets at any point in an action chain with the help of the [[transformations:sandbox|Sandbox action]]\\ | * Insertion of arbitrary datasets at any point in an action chain with the help of the [[transformations:sandbox|Sandbox action]]\\ |
| |
=====Action settings===== | =====Action settings===== |
^Setting^Description^ | ^Setting^Description^ |
|Other table|Select the table with the results that will be used in place of the current dataset if it's not empty.| | |Other table|Select the table with the results that will be used in place of the current dataset, if it's not empty.| |
|Mode|Choose which dataset will have priority if both are not empty. Options: //Use this table if it's not empty, otherwise\\ use the other one// or //Use the other table if it's not empty, otherwise use this one//.| | |Mode|Choose which dataset will have priority if both are not empty. Options: //Use this table if it's not empty, otherwise\\ use the other one// or //Use the other table if it's not empty, otherwise use this one//.| |
| |
| \\ |
| =====Community examples===== |
| * [[https://community.easymorph.com/t//675/5|Compare two Excel sheets with EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/xQLWtAogCqcMrglyfXLKmrAF7aR.morph|Project]]; Module: //Main//; Group: //Main//; Table: //Result//; Action position: //2//) |
| * [[https://community.easymorph.com/t//1279/4|Example: Constructing JSON]] ([[https://community.easymorph.com/uploads/short-url/m063pNiVTAgev8a7h7z93mlXbAU.morph|Project]]; Module: //Table2json//; Group: //Tab 1//; Table: //Result JSON//; Action position: //2//) |
| * [[https://community.easymorph.com/t//2186/2|Excel IRR formula]] ([[https://community.easymorph.com/uploads/short-url/r3hO74ebEfwvCgq0YqkKt7bqGM2.morph|Project]]; Module: //NPV//; Group: //Group 1//; Table: //RESULT//; Action position: //3//) |
| |
\\ | \\ |