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?
Solved! Go to Solution.
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
Got it. Thanks!