Question

More than one multi value field data to SQL

Workflow

Updated February 13, 2016

asked on February 13, 2016 • Show version history

I have a template with 3 different Multi value fields. I need to get the data from each multi value field in a SQL database as a separate row I am using the For each value in workflow but it does not give me the result i need.

These fields are Asset Type, Asset Serial Number and Asset Number. So the first value must be in one line in SQL with the corresponding value Thank You

_Asset Tracking_Add Asset.png (6.92 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on February 13, 2016

Not applying an index to the inserted values is likely part of the problem. On the 'For Each Value' activity I used the serial number in my test workflow. Using all three fields can cause additional unwanted entries.
The insert is where the index comes into play. The screenshot below shows how your token should look in the 'Insert Data' activity.

Here is the workflow with the summary:

Here is the database result:

2 0

Replies

replied on February 13, 2016

Hi August,

On the Insert Data activity are you applying an index on your tokens? Also, which value(s) is the For Each Value examining?

0 0

replied on February 13, 2016

Hello Tom

There are no indexing on my tokens

Please find text file with sample data

The first row of each heading represent the Multi value field

I put a end result in SQL that i want each in there own heading

Thank yoiu

Data.txt (234 B)

| Download

0 0

SELECTED ANSWER

replied on February 13, 2016

Here is the workflow with the summary:

Here is the database result:

2 0

replied on February 13, 2016

Hello Tom

Thank you so much for the info It is working 100%

0 0

You are not allowed to follow up in this post.

Question

Question

More than one multi value field data to SQL

Answer

Replies

Sign in to reply to this post.