Filter into Query Database.

Question

Hello to Everyone.

I have a workflow similar to this one.

As you can see, there´s a filter tool there. What i´m looking for is how to transform that filter into a SQL statement, so I can use that code directly into the database, of course, TEST_TABLE is just and example as I know when yo connect to a database building querys looks as the picture below.

Thank you For the Help

TEST_FILTER.yxmd

TEST_TABLE.xlsx

neromerob · Answer

I mean, for all i know everything works well the way it ism but there are some concerns that by using a Filter tool the process could potentially become slower, that´s the reason why i´m looking a way to transform what exist in that filter into a SQL Code.

Christine_Assaad · Answer

Thanks @neromerob

Can't you use the input tool just to pull the columns needed from the DB and then the filter tool to filter it? You don't need to do everything in the SQL editor.

The idea is that if the formula is complex in SQL, you can just pull the data and leverage Alteryx to skip the SQL coding part and still get the job done.

Robin_McIntosh · Answer

If your input tool is connected to a database, why not have the filter as part of your db query?  Or are you wanting to also do something with the 'False' results in a different flow?  Or are you wanting a dynamic filter (interface)?