Hey All,
I'm running a simple setup currently in Alteryx where I feed in a list of IDs and query a view in a database for results.
I used "modify SQL query" option to replace
where ID = 'xxxx' with a list of IDs from another input, this works well for small number of IDs...say less than 100 but if I'm to query a large list with thousands of IDs it would take forever as the dynamic tool is query each individual ID separately.
Is there a better solution? Thanks.
Solved! Go to Solution.
@AbhilashR , no problem, we all learn something new...now this doesn't entirely solve my originally problem as my list is over 1000 IDs, I would need to break it into parts...lol