I'm trying to merge two objects using Automation Studio in Marketing Cloud so a customers opportunities/or no opportunities are all in the one table.
I think this spreadsheet i created will make sense. https://docs.google.com/spreadsheets/d/1DqI63WYpD2yc1pkY4ulDCE9uhC1ABcT5Eb9yhFM8j4k/edit?usp=sharing
There are three types of accounts and opps. 1) Accounts with 1 opp 2) Accounts with many opps 3) Accounts with no opps
I need to have all three types of customers appear in the one table with all opps associated.
Hope this makes sense! Thanks