We have a parent-child relationship between opportunity and case object(ie- an opportunity can be related to multiple cases). We need to show a report of all those opportunities which is not related to a case.

Please let me know if this is possible via single data-set.

  • We are able to meet the requirement after cogrouping two data-set of opportunity and case. But I am not able to find a way out of a single data-set. – Sam R Sep 18 '17 at 5:59

Hope this helps You can make opportunity and case object in single dataset by using augment function of dataflow

Here is how You do it

  1. Using SfdcDigest get both case and opportunity objects in dataflow
  2. select id field in opportunity and opportunityId(Your custom lookup filed) field in case
  3. create new augment function in left source select sfdcDigest of case and leftkey as opportunityId
  4. Relationship: is your desired string
  5. in right source select sfdcDigest of opportunity and Right Key as id then save
  6. add sfdcRegister to augment there you have it single dataset
| improve this answer | |
  • this will give me all those opportunity where cases are attached. I need all those case where cases are not attached. – Sam R Apr 10 '19 at 10:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.