combining columns in an update, intermediate kdb question 7

Community Support
1

hi all, 

so i have a table with two symbol columns, and im creating a third column which is a concatentaion of the other two, also a symbol column. i have the following code:

which works fine, but when i try to do this within one statement i get an error:

 

how can i make adjustments to do this in one line, as i want to write it in functional form also .

thanks all!

 

2

As , is used to separate operations in a select query you need to wrap in parenthesis:

 

 

q)update ric:exch(,)'sym from (exch:an;sym:hg) exch sym ric ------------ a h a h n g n g

 

 

3

thank you!