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