Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using multiple Dynamic Input Tools to run more than 1000 IN list values in a PL/SQL query

nordmaeo
7 - Meteor

I am attempting to run multiple dynamic input tools as a work around for PL/SQLs limit of 1000 IN list values in a SQL statement. My output has around 9000 list values that I am trying to pass through my query(I created a record ID and filter 1000 rows at a time into the Dynamic Input Tools), however filtering and using multiple dynamic input tools seems to freeze my workflow.

 

Is there a more efficient workaround for feeding more than 1000 IN list values through a SQL query?

 

Any help is much appreciated!

 

Thanks,

Eoin

2 REPLIES 2
Ladarthure
14 - Magnetar
14 - Magnetar

Hi @nordmaeo,

 

what we do when we face this kind of problem is using the data-stream in and create a temporary table that we join afterwards with the "full database", you may have to ask your db admin to check if you can create a temporary table.

 

 

nordmaeo
7 - Meteor

Thanks! I was trying that earlier but I think I was joining on different data types, which was freezing the IN-DB join, or rather, the workflow stops at the data stream out tool. I'll give it another shot.

Labels