I have two datasets blending. The underlying sets are sourced from (1) CRM opportunities with contact roles, and (2) CRM leads and converted lead information.
In essence, I join the data and then summarize by Opportunity, and include the Minimum "date" field of the contacts roles dates associated to the opportunity. To achieve this, my summarize configuration appears like the below:
What I'd also like to include in the summarize tab is an ID field from the joined data, for reference & QA sake. I want to log into the CRM and view the original records to verify the date provided in the summarization is accurate.
How can I include a this ID field in my summary tab (which is not pictured) to include it with the output data where I have the minimum "Lead Created Date" for each opportunity and the associated ID that provided the Minimum Date. I've done this in Excel with some really messy array formulas, but surely there is a way to do it simply in Alteryx.
Any guidance is much appreciated! Note, I can't upload the original files given information is sensitive but here's a screenshot of my workflow:
