How to update SQL with data from multiple value fields?

asked on November 16, 2016

Hi guys,

How do you populate a SQL table from Workflow with regard to multivalue fields please? I've got a Retrieve Field Values activity which includes three fields I need to get into SQL - I ultimately need them in an Update Word activity table so I have to insert them into SQL first in order to then query SQL to add them to the Word Table Merge). The first field is a single value reference field ("Job Number"), the other two fields are for components and their prices so are multivalue. I've tried various approaches with multivalue tokens and "For Each Value" activities, but I keep ending up with the same data across multiple rows in SQL.

Thanks,

Mike

0 0

SELECTED ANSWER

replied on November 16, 2016

I'm guessing that the problem is that you can iterate through one of the fields, but you're still referencing the field token for the other multi-value field.

For Each Value provides an "iteration" token you can use to match the values from the second field to the first one.

This setup matches the first value from Field A with the first value from Field B and inserts them into your data source, the second value to the second value and so on.

0 0

replied on November 16, 2016

That was the problem and the answer Miruna, thanks very much for that.

0 0

Question

Question

How to update SQL with data from multiple value fields?

Answer

Replies

Sign in to reply to this post.