Hi,
So I have a complex group set-up in my Primary data source. I need to use this group in my secondary data source, however, it is greyed out and not usable.
Is there a slicker solution to achieving this rather than re-create the group in the secondary data source?
Many thanks and regards.
Hi Paolo,
Drag desired field from your PRIMARY source on to the ROWS shelf.
Add matching field from SECONDARY data source and nest it next to the existing field on the ROWS shelf.
Right-click the SECONDARY field on the ROWS shelf and select ‘Create Primary Group’.
NOTE: make sure you check the Include ‘Other’ check box
Verify the group is now in your PRIMARY data source.
That’s it! You no longer need to blend or use the SECONDARY SOURCE field.
There is one gotcha to be aware of: If a record is added to the dimension you’re grouping in the primary data source, a new person in this example, you will have to regenerate the group or the new person will automatically get put into the “Other” group. Creating a primary group does not dynamically update.
Let me know if this is the solution you are looking for! If it is, Please don't forget to mark helpful and/or correct answer
Best Regards,
Yasin.
