Can I make Alteryx a Quiz Master?

In 2020 everyone is spending more time at home and having video calls with families, friends and colleagues and some are holding quizzes during these calls. It led me to think was it possible to use Alteryx to host these. The short answer is yes you can! I have to acknowledge this is not an original idea and Dr Tim Rains (DRains) first showed me this was possible in 2018. I did though take this on as a challenge, with the objective of not reaching out to him to ask how he solved this. Therefore on a Saturday morning I came up with the following to make Alteryx a Quiz Master.

It was relatively easy to build a process in Alteryx the below screenshot shows the entire workflow, a text input of words you want your computer to speak and a batch macro. In summary how this works is each row of the text input, is read into the batch macro. Per batch the computer speaks out the text within that row of data, plus also waiting a specified amount of time to give the quiz participants time to write down their answers.

Workflow Overview

The Text Input holds all the text I want my computer to speak, including a welcome message and a list of questions to be asked.

Text Input of words to be spoken

The configuration of the batch macro is really simple with no fields being used in the Group By tab and then for the Questions tab I’m using the field “Questions”, which has all the text to spoken by my computer.

Batch Macro Configuration

The macro itself has few tools a Macro Input a Filter tool which is being used  to select the correct batch every time it runs. Then the next tool is WaitASecond which I can specfity the amount of seconds before the data in the macro is passed downstream in the macro.

Batch Macro Overview

The WaitASecond tool is actually a CReW Macro released in 2016 more information about this macro can be found here.

WaitASecond Tool Overview

In the Formula tool I am creating two columns one is a VBS_script with the Question column with the text to be spoken, being inputted as a parameter per batch. The second column is a File path location to output the file later in the process.  

Formula Tool VBS Syntax Creation

Next in the process I use a Select tool to remove unwanted fields however it not a requirement. I use a Blob Convert tool, to convert the VBS_Script field created in my Formula tool into a Blob data type.

Blob Convert

The reasons for this conversation is shown in the Blob Output tool, where I output the Blob field as a VBS file. With also the option of “Modify File Name By:” with the drop down of “Replacing Entire Path with Field” using the column “Field”.

Blob Output

The result of this Blob conversation and output is a VBS file, where the highlighted text is being replaced per batch. This VBS file alone will play once it’s clicked however I want the file to be played automatically without needing to be clicked.

VBS File Syntax

This is where the Run Command tool comes in and executes a batch file, which calls on the VBS file I’m creating per batch. These makes my computer speak the text within that VBS file every batch.

Run Command Overview

The syntax within the bat file is very simple it’s just start and the name of the VBS file.

Batch File Syntax

The result of all of this is when I press run in Alteryx Designer is that Alteryx will now become a quiz master and starts to fire off questions.

Hope you find this blog helpful and seen how easy it is to turn Alteryx in a quiz master. Please leave a comment or reach out to me on Twitter @JosephSerpis or on the Alteryx Community and Linkedin.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s