send the content of one column of a table to another table

send the content of one column of a table to another table

[Uwe Brauer]

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.

So I have
 
#+tblname: master | type     | Fiber | Sugar | Protein | Carb | 
type | |----------+-------+-------+---------+------+------| | 
eggplant |   2.5 |   3.2 |     0.8 |  8.6 |      | | tomatoe  | 
0.6 |   2.1 |     0.8 |  3.4 |      | | onion    |   1.3 |   4.4 | 
1.3 |  9.0 |      | | egg      |     0 |  18.3 |    31.9 | 18.3 | 
| | rice     |   0.2 |     0 |     1.5 | 16.0 |      | | bread 
|   0.7 |   0.7 |     3.3 | 16.0 |      | | orange   |   3.1 | 
11.9 |     1.3 | 17.6 |      | | banana   |   2.1 |   9.9 | 
0.9 | 18.5 |      | | tofu     |   0.7 |   0.5 |     6.6 |  1.4 | 
| | nut      |   2.6 |   1.3 |     4.9 |  7.2 |      | | corn 
|   4.7 |   1.8 |     2.8 | 21.3 |      |   #+TBLNAME: statistics 
| type    | Protein | |---------+---------| | eggplan |         | 
| tomatoe |         | | onion   |         | | egg     |         | 
| rice    |         | | bread   |         | | orange  |         | 
| banana  |         | | tofu    |         | | nut     |         | 
| corn    |         | 
 
 

So all the time a change the content of the protein column in 
master table I want to send that change to the statistics table. 
How can I achieve that?

Thanks

Uwe Brauer 

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

[Uwe Brauer]

>>> "Uwe" == Uwe Brauer <oub@mat.ucm.es> 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