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?
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.
x:(a:1 2 3;b:`I`J`K;c:10 20 30)
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700