User Tools

Site Tools


transformations:trimbycondition

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:trimbycondition [2021/05/12 15:02] – [Description] dmitrytransformations:trimbycondition [2021/07/18 00:07] craigt
Line 30: Line 30:
 \\  \\ 
 **Action parameters:** **Action parameters:**
-> Condition is "[Store/ City]=('Total in Montreal')"+> Condition is [Store/ City]='Total in Montreal'
 > Delete rows that are "Above the first match" > Delete rows that are "Above the first match"
 > Delete the first matching row too (checked) > Delete the first matching row too (checked)
 \\  \\ 
-**Result:**+**Result table:**
 ^Store/ City  ^Jan-15  ^Feb-15  ^ ^Store/ City  ^Jan-15  ^Feb-15  ^
 | Store 1-Toronto  |  29800|  33691| | Store 1-Toronto  |  29800|  33691|
Line 40: Line 40:
 | Store 3-Toronto  |  41238|  45390| | Store 3-Toronto  |  41238|  45390|
 | **Total in Toronto**  |  **108502**|  **119331**| | **Total in Toronto**  |  **108502**|  **119331**|
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//2267/1|How to parse EDI file (e.g. X12 transaction set 837)]] ([[https://community.easymorph.com/uploads/short-url/6tzpyfamtKPeOq37FyUjBxKud4F.morph|Project]]; Module: //Main//; Group: //Header//; Table: //Raw header//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//2267/1|How to parse EDI file (e.g. X12 transaction set 837)]] ([[https://community.easymorph.com/uploads/short-url/6tzpyfamtKPeOq37FyUjBxKud4F.morph|Project]]; Module: //Main//; Group: //Raw EDI//; Table: //Raw EDI X12//; Action position: //5//)
 +  * [[https://community.easymorph.com/t//2711/2|My first experiment API + conditional workflow + iteration]] ([[https://community.easymorph.com/uploads/short-url/jG4qopOtRfSxDo0UFJkNbBaKvac.morph|Project]]; Module: //Main//; Group: //Acquisition data via API//; Table: //Data from API//; Action position: //5//)
  
 \\  \\ 
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki