I’m new to Analytics Studio and looking to create a unified dataset that combines contacts and leads, which isn’t possible with standard Salesforce dashboards. I aim to track data quality issues.. In my current Salesforce dashboard, I have separate components for things like missing company name, by object. How can I create a combined dataset in Analytics Studio to display this data in one component? I don't have access to create data sets yet, but I'm just curious if someone is doing this regularly, and if indeed a data set/recipe is needed. Many thanks!
You can digest data from Lead object and Contact object in a recipe. Then use an append node and match the columns from Lead and Contact object as required. Finally use an output node to create the dataset.