Run a query 1000 records at a time

Question

Hello.  New to the Alteryx world.  We use several Oracle instances, limiting our "in" clause to 1000 records at a time.  We are often asked for status (for example) for 10,000 lines.  I have been playing with the Dynamic Input tool, but have not been able to get this to work.  Anyone have an example in which you create a loop where n number of records are queried at a time?

MarqueeCrew · Accepted Answer

Oracle allows for an offset in the  SQL as:

OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY;

So if you take your initial query as a template and use a dynamic query reading in a list of offsets, you can replace the offset number of 0 with the actual offset and you will run many queries each with a limit of 1,000.

Cheers,

Mark