{{ transformations:TrimByConditionAction.png}}
====== TRIM TABLE BY CONDITION ======
Category: Transform / Filters\\

\\ 
=====Description=====
This action removes the rows above or below the first row where the specific [[syntax:start|condition]] is true.\\

\\ 
=====Action settings=====
^Setting ^Description ^
|Condition|Enter an expression that evaluates to TRUE or FALSE.|
|Delete rows that are|Select whether the rows above or below the first match are removed.  Options: //Above first match// or //Below\\ first match//.|
|Delete first matching row too|When checked, the first row that satisfies the //Condition// is removed as well as the rows above/below it.|

\\ 
=====Examples=====
**Example:** Remove the rows with Montreal sales.\\

**Table:** The company sales in the stores of Montreal and Toronto
^ Store/ City  ^Jan-15  ^Feb-15  ^
| Store 1-Montreal  |  30359|  35018|
| Store 2-Montreal  |  24500|  28251|
| Store 3-Montreal  |  32721|  34300|
| **Total in Montreal**  |  **87580**|  **97569**|
| Store 1-Toronto  |  29800|  33691|
| Store 2-Toronto  |  37464|  40250|
| Store 3-Toronto  |  41238|  45390|
| **Total in Toronto**  |  **108502**|  **119331**|
\\ 
**Action parameters:**
> Condition is [Store/ City]='Total in Montreal'
> Delete rows that are "Above the first match"
> Delete the first matching row too (checked)
\\ 
**Result table:**
^Store/ City  ^Jan-15  ^Feb-15  ^
| Store 1-Toronto  |  29800|  33691|
| Store 2-Toronto  |  37464|  40250|
| Store 3-Toronto  |  41238|  45390|
| **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=====
  * [[transformations:keepremovematching|Keep/remove matching]]
  * [[transformations:trimtable|Trim table]]