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:29] – elenap | transformations:trimbycondition [2015/05/01 13:33] – elenap | ||
---|---|---|---|
Line 5: | Line 5: | ||
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