We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Cleaning up MS Teams transcripts using Alteryx

DKMI
7 - Meteor

msHi

 

I have extracted some conversations from MS Teams, hoping to conduct some topic analysis. The data comes out of teams like this:

 

DKMI (Derek)   27:46
So it it's definitely something that people are looking at and people are are I, I would say two fold I do do think there are some concerns some because we are in pharma sales in the US things can be dynamic and go either way from time to time.
 
External user - external comany   27:58
No.
 
DKMI (Derek)   28:03
But I I do think there's a genuine excitement and curiosity about where we're going as as an organization.
 
External user - Implement Consulting Group   28:05
Yeah.
And also the rest of this call, can you kind of echo that or how do you see it?
 
DKMI (Derek)    28:17
And if I should come?
So I sit in on eating right and still therapy and I think in and we I probably cannot recognize it, but it's also I guess it driven by the the different work we do, right.
 
PMRB (Peter) 28:18 
So it it's definitely something that people are looking at and people are are I, I would say two fold I do do think there are some concerns some because we are in sales in the US things can be dynamic and go either way from time to time.

 

In essence, we can identify the person speaking as the characters before the first space on a row containing xx:xx tell us, and the text containing the transcription my be on the subsequent one (or more) lines.

 

What might the flow look like to wrangle it into the following:

 

DKMIHas anyone done that before?
External userNo.
DKMIBut I I do think there's a genuine excitement and curiosity about where we're going as as an organization.
External userYeah. And also the rest of this call, can you kind of echo that or how do you see it?
DKMIAnd if I should come? So I sit in on eating right and still therapy and I think in and we I probably cannot recognize it, but it's also I guess it driven by the the different work we do, right.
PMRBSo it it's definitely something that people are looking at and people are are I, I would say two fold I do do think there are some concerns some because we are in sales in the US things can be dynamic and go either way from time to time.
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @DKMI 

 

See if this is what you need:

 

Screenshot 2023-08-29 094834.png

DKMI
7 - Meteor

Are you a wizard?!?

 

That is an awesome solution!

 

Labels
Top Solution Authors