I currently have an Oracle query that generates a list of customer ID’s. Usually anywhere between 300-500 Customer ID’s every time the query runs.
Then I have a second query that uses those generated Customer ID’s and pull additional data.
WHERE CUST_ID IN (CUSTOMER_ID1, CUSTOMER_ID2, CUSTOMER_ID3…etc…)
Now I am building this process within UiPath and I generated the first query which provided me with a Datatable and a column with ALL of the Customer ID’s.
Now my problem is that I cannot feed all of those Customer ID’s at once to the second query because of technical limitations in the database (size overflow basically).
So what I am forced to do is actually split the Customer ID’s into multiple batches. For example if I have 400 Customer ID’s , I would run the query 4 times with 100 Customer ID each time.
Given that Scenario, does anyone have a good solution on how to split up the Array of Customer ID’s that I have into multiple subarrays. For example, if we had 350 Customer ID’s in the master array, we would want 100 in array 1, 100 in array 2, 100 in array 3 and 50 in array 4.