From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 2HElDmCK3F7+WQAA0tVLHw (envelope-from ) for ; Sun, 07 Jun 2020 06:34:08 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id iHsGCmCK3F4LWwAAB5/wlQ (envelope-from ) for ; Sun, 07 Jun 2020 06:34:08 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id A4D5594053A for ; Sun, 7 Jun 2020 06:34:07 +0000 (UTC) Received: from localhost ([::1]:55956 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jhosg-0001Pd-92 for larch@yhetil.org; Sun, 07 Jun 2020 02:34:06 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:52002) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jhosK-0001PV-3G for emacs-orgmode@gnu.org; Sun, 07 Jun 2020 02:33:44 -0400 Received: from smtp1-g21.free.fr ([2a01:e0c:1:1599::10]:33792) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jhosI-0008JA-V2 for emacs-orgmode@gnu.org; Sun, 07 Jun 2020 02:33:43 -0400 Received: from [IPv6:2a01:e35:39f3:4610:a90b:e15:47dc:49d8] (unknown [IPv6:2a01:e35:39f3:4610:a90b:e15:47dc:49d8]) by smtp1-g21.free.fr (Postfix) with ESMTPS id DD56CB0052C for ; Sun, 7 Jun 2020 08:33:39 +0200 (CEST) Subject: Re: join tables from different files To: emacs-orgmode@gnu.org References: <878sh0q66c.fsf@mat.ucm.es> From: tbanelwebmin Message-ID: Date: Sun, 7 Jun 2020 08:33:39 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <878sh0q66c.fsf@mat.ucm.es> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US Received-SPF: none client-ip=2a01:e0c:1:1599::10; envelope-from=tbanelwebmin@free.fr; helo=smtp1-g21.free.fr X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, FREEMAIL_FROM=0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.01 X-TUID: mduU/8lPnZJU Yes you can. Use an org-id Suppose you have a table in file x.org, under some title: --------- x.org ---------------------- * title | a | b | |----+----| | aa | 5 | | bb | 7 | | aa | 11 | -------------------------------------- Add an ID by calling: M-x org-id-get-create. You end up with: --------- x.org ---------------------- * title :PROPERTIES: :ID: c8b8bb22-e42e-426f-afb0-4cb19aed27ad :END: | a | b | |----+----| | aa | 5 | | bb | 7 | | aa | 11 | -------------------------------------- Globally save the new ID by calling M-: (org-id-locations-save). You will see c8b8bb22-e42e-426f-afb0-4cb19aed27ad in the ~/.emacs.d/.org-id-locations file. In another file, say y.org, you may now reference this remote table with the ID in an aggregated, transposed, or joined block: --------- y.org ---------------------- #+BEGIN: aggregate :table "c8b8bb22-e42e-426f-afb0-4cb19aed27ad" :cols "a vsum(b)" | a | vsum(b) | |----+---------| | aa | 16 | | bb | 7 | #+END: -------------------------------------- The wizard for creating the aggregated (or joined, or transposed) block does not (yet) complete remote tables names, only buffer-local ones. The wizard may be called with C-c C-x x (or C-x C-x i on older versions of Org Mode). Note that those global IDs are also used by the spreadsheet remote() function. Example: --------- z.org ---------------------- | b | | 5 | | 7 | | 11 | #+TBLFM: $1=remote(c8b8bb22-e42e-426f-afb0-4cb19aed27ad,@@#$2) -------------------------------------- Have fun Thierry Le 06/06/2020 à 22:40, Uwe Brauer a écrit : > Hi > > I know I can either user > (org-insert-dblock:aggregate) > (org-insert-dblock:join) > > To join or aggregate tables with in the same files. > > But can I join tables from different files? > > Thanks > > Uwe Brauer > > >