Forum Discussion

dexterwoolfe's avatar
dexterwoolfe
Frequent Visitor
8 years ago

Separating multiple values for an ID into different columns

I have 2 tables. A table with lead details and a table with contact info both have a LeadID column.   Some leads have several phone numbers and I just wanted to know how I can create a table with a...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi dexterwoolfe,

 

You can separate them using Split Column in the Query Editor.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

dexterwoolfe's avatar
dexterwoolfe
Frequent Visitor
8 years ago

Hi v-jiascu-msft

 

Unfortunatley this wouldn't work in this instance as the various phone numbers aren't in the same cell. They are in a seperate table on different rows under the same 'LeadID.' Hopefully the below screenshot will clarify.

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi dexterwoolfe,

     

    Could you please provide a dummy pbix file?

     

    Best Regards!

    Dale