Insert a not matching dictionary to a table

Community Support
,
1

https://learninghub.kx.com/forums/topic/insert-a-not-matching-dictionary-to-a-table

Hello,

I would like to append a row to a table with data that is saved as a dictionary. The dictionary might have additional keys when comparing it to the columns in the table so upsert is not possible. I would like to only upsert the values from the dictionary that have corresponding columns in the dictionary. How is this archived?

 

Sample Code

Dictionary td2 and table x where values for a and b should be appended as rows in table x, column c should be empty and value for key d in dictionary should be discarded.

td2:(`a`b`d)!(99;`a;21)

x:([]a:1 2 3;b:`I`J`K;c:10 20 30)
2 
q){k:key y;x upsert enlist (k where k in cols x)#y}[x;td2] 
a b c 
------- 
1 I 10 
2 J 20 
3 K 30 
99 a
3 
q)x upsert td2 
cols x 
a b c 
------- 
1 I 10 
2 J 20 
3 K 30 
99 a