Forum Discussion

dancarr22's avatar
dancarr22
Icon for Helper V rankHelper V
7 years ago
Solved

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 co...
Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

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