transformations:trimbycondition
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:trimbycondition [2021/05/12 15:02] – [Description] dmitry | transformations:trimbycondition [2023/10/05 00:34] (current) – [See also] dmitry | ||
---|---|---|---|
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]=' |
> 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 |
^Store/ City ^Jan-15 | ^Store/ City ^Jan-15 | ||
| Store 1-Toronto | | Store 1-Toronto | ||
Line 40: | Line 40: | ||
| Store 3-Toronto | | Store 3-Toronto | ||
| **Total in Toronto** | | **Total in Toronto** | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ | ||
=====See also===== | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
- | * [[transformations: | + | * [[transformations: |
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry