Forum Discussion
Create subtable based on comma separated value in main table
Hello,
We are connecting to Dynamics 365 and - in several tables - we have multiselect pick lists. i.e. When we enter a contact we can select multiple values of the 'contact type' for a given contact - example in table below. John Smith is both a Salesperson and an Account Manager.
This contact field is displayed as a comma separated value in PBI table. How can we break this out to display as a separate table? We'd also want to have the contact name so can join back to main Contact table. (In reality would use key/ID fields instead of name - thisis just for the example).
Appreciate any help you can provide.
Thanks,
Dan
Split the 'Contact Type' column on ','
Select the 'Contact Name' and Address columns.
Go to the Transform Menu.
Select 'Unpivot-> Unpivot other columns'
Tidy up the data
