Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
BenoitC
Alteryx
Alteryx

Transcription is now a great feature of Microsoft Stream. When uploading any videos to the Office 365 streaming service, Microsoft can automatically add captions. Once uploaded, you can download transcriptions.

 

BenoitC_0-1630572901875.png

 

Captions are great but not if you want to use it in a readable format:

 

Before Alteryx...

 

BenoitC_1-1630572914574.png

 

After Alteryx...

 

BenoitC_2-1630572926316.png

 

Alteryx is there to back you up! 😎  After extracting the VTT file, you can upload them to this simple workflow to have your text ready:

 

BenoitC_4-1630572958022.png

 

First, you need to download the captions file generated by your video upload. Then get rid of all the time stamps you can see in the above image. You can copy and paste the content of the caption file directly into the Alteryx canvas. This will automatically generate a Text Input tool.

 

BenoitC_5-1630572969724.png

 

Next, keep only the text lines. This is easily done by using two sample tools: one to skip the first rows and the second to gather all the lines of text.

 

BenoitC_6-1630572983057.png

 

Then, concatenate all lines into a single paragraph. One of the cool features of the Summarize tool is the ability to merge multiple lines of text into a single paragraph.

 

BenoitC_7-1630572994751.png

 

Finally, add the Table and Render tools to output the text into a Word document!

 

BenoitC_8-1630573092128.png

 

Follow these steps anytime you need the transcript of a video in a usable format! A meeting recording with a ton of technical terms? Want to quickly paste the transcript into an email? You name it!

 

To sum up, here are the 4 easy steps to follow:

1) Upload a video in Microsoft Stream, captions are automatically activated.

2) Download and copy/paste text from the VTT file (use notepad to open it) directly in the workflow, it will generate a Text Input tool.

3) Add Sample and Summarize tools, click run. Your transcript is readable!

4) Add reporting tools for the Word doc.

 

Enjoy !

 

giphy

Comments
Emil_Kos
16 - Nebula

Hi @BenoitC,

 

Great article!


I think I know one or two people that might be interested in using Alteryx like this. 

 

Could you kindly share your workflow? It will be always one extra step less for someone that would like to use it in practice!