Salesforce SOQL Query creating duplicate table rows

Hey KNIME community. I’m trying to extract data from “hidden” Salesforce tables using SOQL. I’m having issues with the SOQL query creating duplicate Table Rows on the output of the Salesforce SOQL node. These duplicates are actually not present in the underlying table, which I can view in Salesforce directly, but KNIME seems to be struggling to extract all rows distinctly with no duplicates. Wondering if anyone else has encountered this issue and found a solution pertinent for a Salesforce data extract procedure. Thanks for any help/advice/recommendations you can offer.

Is it possible that they are being caused by NULL values? Is it possible that the SOQL query is essentially performing a join because of the WHERE clauses?

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.