String size Issue into Dynamic Input

[flipperdm]

Hello,

I successfully ran a workflow in a previous version but now that I'm using 11.7, I'm getting an exception error when the string is over 2200 records.

Basically, the summary tool is pulling 2233 records, concatenating with commas and replacing a string in the SQL.  Is there another way to do this?

Mark

 

[CharlieS]

I suggest splitting this into multiple records and taking advantage of the built in batch/union of the Dynamic Input tool. I've built the attached solution to show how a couple extra tools can be used to break down your list of clause arguments into subsets of any desired size. Inputting 10 records of 30 rather than 1 record of 300 should output the same from the Dynamic Input tool as it will union the results together.

Check out the attached workflow and let me know if you have any questions.

[flipperdm · Accepted solution]

Exactly!  Thanks.