This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.