Creating multiple value strings with 1000 value limitation

[bobbybalan]

Hello, I would like to pass multiple value strings with 1000 values in each (database constraint) to dynamic input tool instead of single value each time. Passing one value at a time causes time out; can't do anything about that.

I am looking to create a parameter like this -

WHERE (CUSTOMER_ID IN ('1234', '1111',..............1000th value) OR CUSTOMER_ID IN ('33333', '4555',..............1000th value) OR CUSTOMER_ID IN ('1234', '1111'....till the end of the values))

My workflow looks like this -

Input Tool --> Main query db1 to get all CUSTOMER_ID

Summarize tool --> Unique CUSTOMER_ID

Dynamic Tool --> Pass each of the CUSTOMER_ID to read from db2 in a string vs each value

Thanks much for any sample workflow someone can share.

Thanks!

[Raj]

@bobbybalan 
you can create a batch macro
were you can have a list of all the 1000 and you can group them to group of 10 (100 rows) or 50 (20 rows) as per your convenience and then pass these values and your macro will pull them one by one.

this will work without time out limit.

[Raj]

@bobbybalan 
something like this.

[bobbybalan]

Thanks much!