Forum Discussion
making relation between tables when reference column values in other table are appended with comma
Hi All, I have 2 tables one is with list of all contacts and other is the events table where it will reference one or more contacts as attendees. And in the events table multiple contacts are sto...
Hi Bokbob,
I have made a sample data with table ‘Contacts’ and table ‘Events’ based on your description like below:
To make relationship between them based on column [Contacts], click Edit Queries-> table ‘Events’ -> Transform -> Split Column by Delimiter like below:
The result is like below and then you can create a relationship between the two tables based on ‘Contacts’[Contacts] and ‘Events’[Contacts.1].
Regards,
Jimmy Tao
hi Jimmy, I appriciate your reply.
Please see my sample data.
So how to have a relation between these 2 tables based on the names in the first image as names could be more than 1 and can be any in number appended with ','
Please help.