User Tools

Site Tools


transformations:trimbycondition

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
transformations:trimbycondition [2015/05/01 17:29]
elenap
transformations:trimbycondition [2015/05/01 17:33] (current)
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 ​ ^  Feb-15 ​ ^ ^  Store/ City  ^  Jan-15 ​ ^  Feb-15 ​ ^
Line 11: Line 11:
 | Store 2-Montreal ​ |  24500  |  28251  | | Store 2-Montreal ​ |  24500  |  28251  |
 | Store 3-Montreal ​ |  32721  |  34300  | | Store 3-Montreal ​ |  32721  |  34300  |
-| **Total ​(Montreal)**  |  **87580** ​ |  **97569** ​ |+| **Total ​in Montreal** ​ |  **87580** ​ |  **97569** ​ |
 | Store 1-Toronto ​ |  29800  |  33691  | | Store 1-Toronto ​ |  29800  |  33691  |
 | Store 2-Toronto ​ |  37464  |  40250  | | Store 2-Toronto ​ |  37464  |  40250  |
 | Store 3-Toronto ​ |  41238  |  45390  | | Store 3-Toronto ​ |  41238  |  45390  |
-| **Total ​(Toronto)**  |  **108502** ​ |  **119331** ​ |+| **Total ​in Toronto** ​ |  **108502** ​ |  **119331** ​ |
  
  
Line 21: Line 21:
  
 **Transformation parameters:​** **Transformation parameters:​**
-  * Condition: [Store/ City]=('​Total ​(Montreal)')+  * Condition: [Store/ City]=('​Total ​in Montreal'​)
   * 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 ​ |  37464  |  40250  | | Store 2-Toronto ​ |  37464  |  40250  |
 | Store 3-Toronto ​ |  41238  |  45390  | | Store 3-Toronto ​ |  41238  |  45390  |
-| **Total ​(Toronto)**  |  **108502** ​ |  **119331** ​ |+| **Total ​in Toronto** ​ |  **108502** ​ |  **119331** ​ |
transformations/trimbycondition.txt · Last modified: 2015/05/01 17:33 by elenap