string concatenation in select phrase

Community Support
1

when t : (; a : 1  2 3; b : 4 5 6)

I can use 

select a + b from t

but to concatenate string, it’s hard.

Given  t : (; a : “abc” ; b : “ABC”),
how can I concatenate “a” and “A”, “b” and “B” in a select like below?

select a,b from t   will not work.

I can define:

q) cat : ,

q) select cat[a;b] from t  

b

a

b

c

A

B

C

still not work as expected. 

I guess if I can define a cat function that takes character only, it will work. 

But I don’t know how to do it.

Any help?

Thanks!

 

 

2

Hi,
You need to use join each

q)select (a,'b) from t

b

“aA”

“bB”

“cC”

Thanks Rory

3

Hi,

Is this what you are looking for?

q)select (a,'b) from t
b

“aA”
“bB”
“cC”

You should think of a and b as vectors.

Regards,

Paul

4

Yes exactly, 
thank you both Rory and Paul.

5

or

q)(select flip(a;b)from t)~select (a,'b) from t

1b