I have a unique id field. The template and join nodes are there because that’s what we used earlier to make this work. I’m all for simplicity. I removed the template, split and join nodes, and I can update but they’re all the same value because of the missing WHERE.
Correct me if I’m wrong but to map match the id field with my strategy index I’m going to have to write some kind of loop to match the id field with my strategy index. Is that something done in the MSSQL node? I have examples of how that might work using transact-sql and CURSOR, or can I use a function node?