Reputation: 659
I am trying to extract data from Salesforces into Tableau Prep using a simple SOQL query,
SELECT Id,
Amount,
CloseDate,
npsp__Primary_Contact__r.npo02__FirstCloseDate__c
FROM Opportunity
WHERE
CloseDate = THIS_YEAR
AND Id ='1234'
When I run it in Salesforce Dev console I get one record, when i run it in Tableau Prep I get 2 records Id, Amount & CloseDate are identical while one row of npsp__Primary_Contact__r.npo02__FirstCloseDate__c is blank and the other has data in it.
Salesforce Dev is correct, Can anyone offer some tips to debug this?
Upvotes: 0
Views: 7