Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Join tables with dynamic input where clause in Database tools

Highlighted
5 - Atom

Hi I am new to Alteryx. I have to query big postgres table and join with temporary table with where clause so that it will only consider those partitions which are given in where clause. I tried with dynamic input tool but it will eventually goes into low memory issue so I cant go with it. 

Is it possible to join two tables with where clause in Database tools? Any help appreciated, thanks.

Highlighted
17 - Castor
17 - Castor

Hi @rishT

 

Is the list of Partitions that you put in the where clause something that you can calculate before you use the Join In-DB tool? If yes, you can add a Filter In-DB tool before one or both input legs of the join to prefilter the results in the database.

 

Dan  

 

Highlighted
5 - Atom

I want to put condition while joining tables. If I put filter before or after still it will hit all the partitions sequentially and thus joining will take time.

Labels