Is there a way to move data saved in multiple table rows in LF forms into one row in a sql DB? I have done this before with token formatting, creating a token for each field on each possible row a user could add but it doesn't seem to be working the same. The For Each Row will create individual rows for each line but I need to capture each piece of data and put it in the designated column on the same row.
Luckily one of my old co-workers told me how we did it before. The test results don't work like they used to but the process works. Forms collected each row on top of each other, but if you edit the variables in Monitor it shows them individually, they get their own member ID per row. The trick is to index the token at the start and increment for each possible row. So if 4 rows of data come back you create a token for each row and index per row. so tkDataRow1 (index start at 1), tkDataRow2 (index start at 2). Then in the Insert activity, match the right token with the right column. Then they all go on one row in SQL.
You would need to collect the data in a workflow token and store that token into the column.
Best way is probably to use a multivalue token, which you can populate in the for each row loop.
Then put the database insert/update activity outside of the loop. When you set the column, use the token editor and to set "all values separated by" so you can format values as a list separated by commas, semicolons, or whatever you prefer.