[O] [SOLVED aggregate] (was: send the content of one column of a table to another table)

[Uwe Brauer]

>>> "Uwe" == Uwe Brauer <address@hidden> writes:

   > Hi
   > I want to do something simple, just sending (pushing) a column of 
   > one table to another column of another table. I know about 
   > orgtbl-join but I can't get it to work, besides I don't need all 
   > its sophistication.

Hi

It seems that the following does what I want.


#+begin_example



#+NAME: original
| Day       | Color | Level | Quantity |
|-----------+-------+-------+----------|
| Monday    | Red   |    30 |       11 |
| Monday    | Blue  |    25 |        3 |
| Tuesday   | Red   |    51 |       12 |
| Tuesday   | Red   |    45 |       15 |
| Tuesday   | Blue  |    33 |       18 |
| Wednesday | Red   |    27 |       23 |
| Wednesday | Blue  |    12 |       16 |
| Wednesday | Blue  |    15 |       15 |
| Thursday  | Red   |    39 |       24 |
| Thursday  | Red   |    41 |       29 |
| Thursday  | Red   |    49 |       30 |
| Friday    | Blue  |     7 |        5 |
| Friday    | Blue  |     6 |        8 |
| Friday    | Blue  |    11 |        9 |


#+BEGIN: aggregate :table original :cols "Day Color"
| Day       | Color |
|-----------+-------|
| Monday    | Red   |
| Monday    | Blue  |
| Tuesday   | Red   |
| Tuesday   | Blue  |
| Wednesday | Red   |
| Wednesday | Blue  |
| Thursday  | Red   |
| Friday    | Blue  |
#+END
#+end_example