How to join multiple tables

Question

I'm trying to join multiple tables in q

        a                  b                  c
    key | valuea       key | valueb       key | valuec
     1  |   xa          1  |   xb          2  |   xc
     2  |   ya          2  |   yb          4  |   wc
     3  |   za

The expected result is

    key | valuea | valueb | valuec
     1  |   xa   |    xb  |   
     2  |   ya   |    yb  |   xc
     3  |   za   |        |   
     4  |        |        |   wc

The can be acheieved simply with

    (a uj b) uj c

BUT does anyone know how i can do it in functional form? I don't know how many tables i actually have

I need basically a function that will go over the list and smash any number of keyed tables together...

f:{[x] x uj priorx};
f[] each (a;b;c;d;e...)

Can anyone help? or suggest anything?

Thanks!

score 1 · Answer 1 · answered Jun 13 '14 at 05:28

1

figured it out... ;)

f:{[r;t]r uj t};
f/[();(a;b;c)]

answered Jun 13 '14 at 05:28

Rob

793
1
7
8

1

Another way of writing it is : () uj/(a;b;c) – Rahul Jun 13 '14 at 06:43
4

you could further simplify by making `uj` monadic: `(uj/)(a;b;c)` or `uj/[(a;b;c)]` will both do the trick – JPC Jun 13 '14 at 19:05

score 1 · Accepted Answer · answered Jun 13 '14 at 06:59

1

Another solution particular to your problem which is also little faster than your solution:

a (,')/(b;c)

answered Jun 13 '14 at 06:59

Rahul

3,914
1
14
25

How to join multiple tables

2 Answers2

Linked