Alteryx Designer Discussions

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

Input Data PreSQL

Eric227
6 - Meteoroid

I'm trying to grab a large table and it is taking a considerable time to load. I want to limit the importation of the table to only critical records. I thought a good way to do this would be using the PreSQL in the Input Data Tool but I keep getting syntax error. (Incorrect syntax near '=')

 

[audit_reference_dwkey] = 17

3 REPLIES 3
SeanAdams
17 - Castor
17 - Castor

Hey @Eric227 - using PreSQL is good if you need to create a temporary table of some kind, or delete or update something before running the select.

 

If what you're trying to do is to filter the table, the best route is to open the query section of the input tool, switch to the SQL view, and add a "Where" clause.

 

For example if it currently says in the SQL view:

database."tablename"

 

Then change this to:

Select 

     Column A,

     Column B

from TableName

where 

    ColumnA = CriticalValue

 

That will limit the records nicely.

 

Cheers

Sean

SeanAdams
17 - Castor
17 - Castor

Hey @Eric227

 

Happy weekend!

 

Did this help you to get to a solution - if so, would you mind marking this thread as solved?

If not - let's iterate through your question on this thread.

 

Cheers Eric

Sean

Eric227
6 - Meteoroid

This solution works for me

Labels