transformations:trimbycondition
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| transformations:trimbycondition [2015/05/01 13:33] – elenap | transformations:trimbycondition [2021/05/12 11:38] – craigt | ||
|---|---|---|---|
| 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 // | ||
| + | |||
| + | \\ | ||
| + | =====Examples===== | ||
| + | **Objective: | ||
| **Table:** The company sales in the stores of Montreal and Toronto | **Table:** The company sales in the stores of Montreal and Toronto | ||
| + | ^ Store/ City ^Jan-15 | ||
| + | | Store 1-Montreal | ||
| + | | Store 2-Montreal | ||
| + | | Store 3-Montreal | ||
| + | | **Total in Montreal** | ||
| + | | Store 1-Toronto | ||
| + | | Store 2-Toronto | ||
| + | | Store 3-Toronto | ||
| + | | **Total in Toronto** | ||
| + | \\ | ||
| + | **Action parameters: | ||
| + | > Condition is " | ||
| + | > Delete rows that are "Above the first match" | ||
| + | > Delete the first matching row too (checked) | ||
| + | \\ | ||
| + | **Result:** | ||
| + | ^Store/ City ^Jan-15 | ||
| + | | Store 1-Toronto | ||
| + | | Store 2-Toronto | ||
| + | | Store 3-Toronto | ||
| + | | **Total in Toronto** | ||
| - | ^ Store/ City ^ Jan-15 | + | \\ |
| - | | Store 1-Montreal | + | =====See also===== |
| - | | Store 2-Montreal | + | * [[transformations: |
| - | | Store 3-Montreal | + | * [[transformations:keeptop|Trim table]] |
| - | | **Total in Montreal** | + | |
| - | | Store 1-Toronto | + | |
| - | | Store 2-Toronto | + | |
| - | | Store 3-Toronto | + | |
| - | | **Total in Toronto** | + | |
| - | + | ||
| - | + | ||
| - | **Objective: | + | |
| - | + | ||
| - | **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 in Toronto** | ||
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry