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
Last revisionBoth sides next revision
transformations:trimbycondition [2021/05/12 11:38] craigttransformations:trimbycondition [2021/07/19 02:12] – [Examples] craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action removes the rows above or below the first row where the specific condition is true.\\+This action removes the rows above or below the first row where the specific [[syntax:start|condition]] is true.\\
  
 \\  \\ 
Line 16: Line 16:
 \\  \\ 
 =====Examples===== =====Examples=====
-**Objective:** Remove the rows with Montreal sales.\\+**Example:** Remove the rows with Montreal sales.\\
  
 **Table:** The company sales in the stores of Montreal and Toronto **Table:** The company sales in the stores of Montreal and Toronto
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