I have two table:
1. Opportunity: Unique records for each project
2. Opportunity Team: List of team members tagged to a project. Can be more than 1 for a project.
I need to create a values table with unique records for Project information along with all the team members tagged to the project.
I tried left join in the recipe but then the records are getting duplicated due to multiple team members in a team (1-Many relationship).
Is there a way to achieve this? End result should be similar to the screenshot below in Tableau CRM.
Hi Gopal,
Once your compare table is ready you can drop the column with the count/unique by switching over to Query Mode and remove the count/unique part.
eg: ,count(x) as 'X'/ ,unique(x) as 'X'
this will result in the table you want.
