Multi-Value to DB: Workflow Details: • Published: Thursday, July 13, 2017 3:46 PM • Version: 11 Connection Profiles: • Dev 01 (colfdev01) (colfdev01.co.olmsted.mn.us; OC-Dev; WFUser) Multi-Value Tokens: Create the following tokens: • %(Token 1) = 1, 2, 3, 4, 5 (multi-value) • %(Token 2) = test1, test2, test3, test4, test5 (multi-value) • %(Token 3) = 5, 10, 15, 20, 25 (multi-value) • %(Test Combine) (multi-value) Count the Values of Each Token: Create the following tokens: • %(Count Token 1) = %(Token 1#@Count@#) • %(Count Token 2) = %(Token 2#@Count@#) • %(Count Token 3) = %(Token 3#@Count@#) Set Iterations Number: Iterations: %(Count Token 1) + 1 Do Count Match?: Yes: If all of these conditions are true %(Count Token 1) equals %(Count Token 2) %(Count Token 1) equals %(Count Token 3) %(Count Token 2) equals %(Count Token 3) Repeat: If all of these conditions are true %(Repeat_Iteration) is less than or equal to %(Count Token 1) • Limit repetitions to: %(SetIterationsNumber_Iterations) • Evaluate condition before running contained activities • Start the Iteration token at 1 Assign Token Values: Modify the following tokens: • %(Test Combine): Append %(Token 1#[%(Repeat_Iteration)]#) %(Token 2#[%(Repeat_Iteration)]#) %(Token 3#[%(Repeat_Iteration)]#) (multi-value) No: If no other branches run Track Tokens: Report the current value of every token.