You are viewing limited content. For full access, please sign in.

Question

Question

Store Multi-Value Tokens to DB

asked on July 12, 2017 Show version history

I am using 3 multi value tokens: token_name (values contained)

token1 (1, 2, 3, 4, 5)

token2 (test1, test2, test3, test4, test5)

token3 (5, 10, 15, 20, 25)

I want to be able to iterate through as many times as there are values and store in the DB like so:

Column1  |  Column 2  |  Column 3

1                 test1           5

2                 test2           10

3                 test3           15

4                 test4           20

5                 test5           25

 

I am using workflow for each value to get the token iteration.  But the Query is not able to cycle through the values in all the multivalue tokens.

0 0

Answer

SELECTED ANSWER
replied on July 13, 2017

I can make it work if I put it in a Repeat instead of a For Each loop.  To test it I just combined them into tokens but the same principle will work for Insert Data.

 

When I put it in a Repeat I can use the Iteration number to tell it which value of the multi-value token to pull (i.e. iteration 1 pulls first value from start, iteration 2 pulls second value from start, etc.)

 

 

DataInsert.jpg
Multi-Value to DB.png
DataInsert.jpg (83.07 KB)
2 0
replied on July 22, 2017

Thank you,  This worked perfectly.

0 0

Replies

replied on July 13, 2017

Show the section of your workflow that does the "For Each" so that we can see what you are doing.  Then we can help you correct anything that is causing the problem.  Also, have you used a Token Tracker to see if all the multi value tokens are the same length?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.