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

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
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?