Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
macalmon
Contributor
Contributor

Salesforce Connector Load Script Where

Hello, I am trying to use SFDC connector to load records from an object. I connect fine, but I am trying to filter by a field. LOAD and SELECT work fine and data loads, however when I try to use the  WHERE to filter it does not register as a correct syntax.

If I attempt to do the same concept but the data comes from a spreadsheet, the WHERE registers. 

Do anyone have any ideas?

Thank you,

Labels (1)
1 Reply
gavinlaird
Contributor III
Contributor III

WHERE does work with the SFDC connector, but only for non-formula Salesforce fields. Could you please check to see if the field you are trying to filter on is a formula field?