{"action":"created","issue":{"url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/240","repository_url":"https://api.github.com/repos/moebiolabs/moebio_framework","labels_url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/240/labels{/name}","comments_url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/240/comments","events_url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/240/events","html_url":"https://github.com/moebiolabs/moebio_framework/issues/240","id":150075142,"number":240,"title":"merge, join, fusion… functions for Tables","user":{"login":"moebio","id":1260988,"avatar_url":"https://avatars.githubusercontent.com/u/1260988?v=3","gravatar_id":"","url":"https://api.github.com/users/moebio","html_url":"https://github.com/moebio","followers_url":"https://api.github.com/users/moebio/followers","following_url":"https://api.github.com/users/moebio/following{/other_user}","gists_url":"https://api.github.com/users/moebio/gists{/gist_id}","starred_url":"https://api.github.com/users/moebio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moebio/subscriptions","organizations_url":"https://api.github.com/users/moebio/orgs","repos_url":"https://api.github.com/users/moebio/repos","events_url":"https://api.github.com/users/moebio/events{/privacy}","received_events_url":"https://api.github.com/users/moebio/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/moebiolabs/moebio_framework/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/moebiolabs/moebio_framework/labels/medium%20priority","name":"medium priority","color":"bfe5bf"}],"state":"open","locked":false,"assignee":{"login":"moebio","id":1260988,"avatar_url":"https://avatars.githubusercontent.com/u/1260988?v=3","gravatar_id":"","url":"https://api.github.com/users/moebio","html_url":"https://github.com/moebio","followers_url":"https://api.github.com/users/moebio/followers","following_url":"https://api.github.com/users/moebio/following{/other_user}","gists_url":"https://api.github.com/users/moebio/gists{/gist_id}","starred_url":"https://api.github.com/users/moebio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moebio/subscriptions","organizations_url":"https://api.github.com/users/moebio/orgs","repos_url":"https://api.github.com/users/moebio/repos","events_url":"https://api.github.com/users/moebio/events{/privacy}","received_events_url":"https://api.github.com/users/moebio/received_events","type":"User","site_admin":false},"milestone":null,"comments":10,"created_at":"2016-04-21T13:29:54Z","updated_at":"2016-05-05T23:12:35Z","closed_at":null,"body":"I will need some help from @protozoo to have some clarity on which operations, with what options, and under which names these currently exist in coding languages, libraries, and specially sql and SAP.\r\n\r\nNote: some are already, although very likely poorly parametrized and named, part of mo, see:\r\n\r\nTableOperators.mergeDataTables\r\nTableOperators.mergeDataTablesList\r\nTableOperators.sumDataTables\r\n"},"comment":{"url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/comments/217306384","html_url":"https://github.com/moebiolabs/moebio_framework/issues/240#issuecomment-217306384","issue_url":"https://api.github.com/repos/moebiolabs/moebio_framework/issues/240","id":217306384,"user":{"login":"protozoo","id":1389973,"avatar_url":"https://avatars.githubusercontent.com/u/1389973?v=3","gravatar_id":"","url":"https://api.github.com/users/protozoo","html_url":"https://github.com/protozoo","followers_url":"https://api.github.com/users/protozoo/followers","following_url":"https://api.github.com/users/protozoo/following{/other_user}","gists_url":"https://api.github.com/users/protozoo/gists{/gist_id}","starred_url":"https://api.github.com/users/protozoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/protozoo/subscriptions","organizations_url":"https://api.github.com/users/protozoo/orgs","repos_url":"https://api.github.com/users/protozoo/repos","events_url":"https://api.github.com/users/protozoo/events{/privacy}","received_events_url":"https://api.github.com/users/protozoo/received_events","type":"User","site_admin":false},"created_at":"2016-05-05T23:12:35Z","updated_at":"2016-05-05T23:12:35Z","body":"@moebio @Jeff-Clark \r\n\r\nNot sure if this is exactly what you were asking, but I think it can be helpful to think about it in these terms:\r\n\r\nThe merge and aggregate actions are different steps, being executed sequentially.\r\n\r\n1. Merge: Takes 2 or more tables and, based on shared fields and combination rules, generates a new one.\r\n2. Aggregate: Involves only 1 table and reduces it based on aggregation or grouping criteria.\r\n\r\nFor step 1 I don't currently see a need for more than 1 shared field between any two tables.\r\n\r\nFor step 2 I do indeed see the need of multiple variables. An example would be a table with these columns:\r\n\r\n- year\r\n- month\r\n- date\r\n- week_day\r\n- total_sales\r\n\r\nAs an analyst I may want to aggregate based on **year** and **week_day** so that I get 1 row for each combination of **year / week_day**. \r\n\r\nDoes it help somehow?\r\n\r\n\r\n"}}