Question

Replicating Data from a Multi-Value Field Being Written to SQL from Workflow

Workflow

Updated February 7, 2020

asked on March 4, 2014

Hi,

I have created a workflow that retrieves field data and then inserts the data to a SQL table. My problem is one of the fields is a multi-value field.

Under Retrieve Field Value I selected All Values and the Values at the Indices 1, 2, and 3. If I am only writing one field to my table it replicates 3 times. If I have 2 the first value is fine and the second value replicates 2 times and if I have 3 values then it is perfect.

What can I do to stop the replication? Thank you

0 0

Answer

SELECTED ANSWER

replied on March 7, 2014

Hi Again,

I actually figured it out. My syntax was wrong. Thank you so much for your help!

0 0

Replies

replied on March 4, 2014

How are you going about inserting the data to the SQL Table?

I would simply use a "For Each Value" set to the multi-value field and then "Insert Data" using the other values and the current value from the "For Each Value" Activity.

If dealing with multiple multi-value fields, you might need to layer the "For Each Value" activities

1 0

replied on March 7, 2014

Hi,

I tried what you suggested and it worked in the sense if I wanted to write to SQL multiple times. I want the multi-line value to write without repeating its last line within one submission to SQL.

example:

The multi-line value has 5 indices and if I just want to write 3 it looks like this:

test1, test2, test3, test3, test3

I have no idea how to fix this

Thank you

0 0

replied on February 7, 2020

Hi Jennifer,

How you solve this problem?

What workflow activities have you been used and how you arrange them?

Thanks

0 0

You are not allowed to follow up in this post.

Question

Question

Replicating Data from a Multi-Value Field Being Written to SQL from Workflow

Answer

Replies

Sign in to reply to this post.