Input Data PreSQL

[Eric227]

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

[SeanAdams · Accepted solution]

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]

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]

This solution works for me