transformations:trimbycondition
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:trimbycondition [2015/05/01 13:29] – elenap | transformations:trimbycondition [2023/10/05 00:34] (current) – [See also] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Trim Table by Condition | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====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. | ||
+ | |Delete first matching row too|When checked, the first row that satisfies the // | ||
- | **Table:** The company sales in stores of Montreal | + | \\ |
+ | =====Examples===== | ||
+ | **Example:** Remove the rows with Montreal | ||
- | ^ Store/ City ^ Jan-15 | + | **Table:** The company sales in the stores of Montreal and Toronto |
- | | Store 1-Montreal | + | ^ Store/ City ^Jan-15 |
- | | Store 2-Montreal | + | | Store 1-Montreal |
- | | Store 3-Montreal | + | | Store 2-Montreal |
- | | **Total | + | | Store 3-Montreal |
- | | Store 1-Toronto | + | | **Total |
- | | Store 2-Toronto | + | | Store 1-Toronto |
- | | Store 3-Toronto | + | | Store 2-Toronto |
- | | **Total | + | | Store 3-Toronto |
+ | | **Total | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Condition is [Store/ City]=' | ||
+ | > Delete rows that are "Above the first match" | ||
+ | > Delete the first matching row too (checked) | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^Store/ City ^Jan-15 | ||
+ | | Store 1-Toronto | ||
+ | | Store 2-Toronto | ||
+ | | Store 3-Toronto | ||
+ | | **Total in Toronto** | ||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
- | **Objective:** Remove the rows with Montreal sales. | + | \\ |
+ | =====See also===== | ||
+ | | ||
+ | | ||
- | **Transformation parameters: | ||
- | * Condition: [Store/ City]=(' | ||
- | * Delete rows that are: Above the first match | ||
- | * Delete the first matching row too (check the box) | ||
- | |||
- | **Result:** | ||
- | |||
- | ^ Store/ City ^ Jan-15 | ||
- | | Store 1-Toronto | ||
- | | Store 2-Toronto | ||
- | | Store 3-Toronto | ||
- | | **Total (Toronto)** |
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry