CODEWITHSUNDEEP
joinkdb+q-lang
Hopper06
Hopper06

Reputation: 89

kdb simple table join unexpected result

I am trying out the example on how to join two tables found at http://code.kx.com/q/ref/lists/#join

The example shows:

 t:([]a:1 2 3;b:`a`b`c)
 r:([]c:10 20 30;d:1.2 3.4 5.6)
 show t,`r

with this as the result:

     a b c  d
     ----------
     1 a 10 1.2
     2 b 20 3.4
     3 c 30 5.6

However, when I try it in my q console, I am getting this result:

   q)t,`r
   `a`b!(1;`a)
   `a`b!(2;`b)
   `a`b!(3;`c)
   `r

Can someone please explain what is happening, and what I am doing wrong?

Upvotes: 1

Views: 127

Answers (1)

terrylynch
terrylynch

Reputation: 13582

It's a tick ('), not a backtick (`)

So it should be

t,'r

not 

t,`r

Upvotes: 3

Related Questions