pfullen1997
Forum Replies Created
-
Not too sure on a more elegant and generalisable way, but this code will produce the desired result:
(flip enlist[`a]!enlist[t `a]),’flip `b1`b2`b3!t `b
-
The values aren’t stored out of order. As the ID column is acting as a foreign key, the corresponding v values to each ID from the kt table are as follows:
ID v 1002 200 1001 100 1003 300 1001 100
That’s why they appear in the order they do in the select query. Hopefully that’s clear enough.