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?