A question about transformations
Daniel Walters 12 years ago • updated by anonymous 7 years ago • 3
I've looked at the transformation pages already.
My question is
If you have two tables: People and Roles. There's a one to many relationship ie. a person can have many roles.
Is there a transformation that can return distinct People with a multivalued attribute that contains each Role? I think the answer is no but I'm not 100% certain and I don't want to advise the wrong thing.
Customer support service by UserEcho
Are the table definitions like this:
If so, do you think something like this would work?
Yeah I think that would work. Thanks Adam.