transformations:trimbycondition
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:trimbycondition [2015/05/01 13:28] – created elenap | transformations:trimbycondition [2015/05/01 13:33] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Trim Table by Condition ===== | ===== Trim Table by Condition ===== | ||
- | This transformation removes the rows above or below the first row where the given condition is true. | + | This transformation removes the rows above or below the first row where the specific |
EXAMPLE | EXAMPLE | ||
- | **Table:** The company sales in stores of Montreal and Toronto | + | **Table:** The company sales in the stores of Montreal and Toronto |
^ Store/ City ^ Jan-15 | ^ Store/ City ^ Jan-15 | ||
Line 11: | Line 11: | ||
| Store 2-Montreal | | Store 2-Montreal | ||
| Store 3-Montreal | | Store 3-Montreal | ||
- | | **Total | + | | **Total |
| Store 1-Toronto | | Store 1-Toronto | ||
| Store 2-Toronto | | Store 2-Toronto | ||
| Store 3-Toronto | | Store 3-Toronto | ||
- | | **Total | + | | **Total |
Line 21: | Line 21: | ||
**Transformation parameters: | **Transformation parameters: | ||
- | * Condition: [Store/ City]=(' | + | * Condition: [Store/ City]=(' |
* Delete rows that are: Above the first match | * Delete rows that are: Above the first match | ||
* Delete the first matching row too (check the box) | * Delete the first matching row too (check the box) | ||
Line 31: | Line 31: | ||
| Store 2-Toronto | | Store 2-Toronto | ||
| Store 3-Toronto | | Store 3-Toronto | ||
- | | **Total | + | | **Total |
transformations/trimbycondition.txt · Last modified: 2023/10/05 00:34 by dmitry