Input Data PreSQL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This solution works for me
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)