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
transformations:trimbycondition [2021/05/12 11:38] craigttransformations:trimbycondition [2023/10/05 00:34] (current) – [See also] dmitry
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//)
  
 \\  \\ 
 =====See also===== =====See also=====
   * [[transformations:keepremovematching|Keep/remove matching]]   * [[transformations:keepremovematching|Keep/remove matching]]
-  * [[transformations:keeptop|Trim table]]+  * [[transformations:trimtable|Trim table]]
  
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki