Hi Miruna

I assigned multi value for each column in SQL Table but but I couldn't insert all the rows.   It only inserts last row into the Forms table.   I even put the the "Set Business process Variables" out side "For each Row" loop and the result is the same.  

In the following image what am I doing wrong:

Hi Farzali,

I think the "Set Business Proces Variables" activity is outside the scope of the "For each row" activity, so it only inserts the last record.

The "For each row" activity is out ....

Move "Set Business Proces Variables" activity into "For each row"activity

regards,

Marco.

Hello Marco

I had tried that already and tried again but the result is the same.  I am only getting the last row.

Hi Farzali,

Try removing the "Asign token..." activity, and assign the values ​​directly.

Can you show the definition of you form fields as well as the properties of the Set Business Process Variables activity? They don't look like table fields.

here are the detail requested

Oh, sorry, I should've seen it straight away. You're creating the multi-value token inside For Each Row. So it's re-created at every iteration with only one value, the current one.

Create the ReqID, VendorName and other tokens before you go into For Each as blank multi-value tokens. Then inside For Each Row, modify them to append the values.

(You can copy the Assign Tokens activity and paste  it up, then remove the For Each tokens from the values. Then for the one inside For Each Row, you can right-click on each token and choose "Change Action to 'Modify'" from the context menu so you don't have to reconfigure it from scratch).

Thanks Miruna, it worked.  Appreciate the hlep.

Hello Miruna

I just noticed row number one gets duplicated, how can I get around this?