Does anyone know how to work with audio or non-standard file formats?

[coderockride]

Does Alteryx have a way to deal with a file type that doesn't show up in the Input or Dynamic Input tools?

I recently used Azure APIs to translate text and do sentiment analytics which I thought was massively powerful. I would now like to see if I could use Azure APIs to transcribe audio, however I don't know how to simply convert an audio file to a json payload because I don't know how to input an audio file.

[danilang · Accepted solution]

Hi @coderockride

The Blob Input tool on the Developer tool bar will open any file and present the results as a blob.  From there you can manipulate in any way you see fit.

Dan

[coderockride]

Ah I thought I had looked at this before. Thanks. Will give it a try and report back.

[coderockride]

Thanks for the guidance. This was actually quite easy. The hardest part was working how exactly to call the API. It would be great if Alteryx published some download tool configurations for popular APIs.

Now I just need to figure out how to convert my mp3/m4a files to wav as required by the API. Hopefully I can download a desktop program and use the run command.

[danilang]

Hi @coderockride

The program I use for my audio processing is Audacity.  Free and very well regarded and supported.  I believe it has command line/scripting options that will convert to wav.  If not ffmpeg( also free and good) should be able to it.

Dan

[danilang]

Hi @coderockride

As an aside What does the Rock stand for.  Music or rock climbing?  If it's the latter, I play bass

Dan

[coderockride]

Thanks, sounds like I've got my Saturday planned.

Nice catch, I used to be a guitarist, but now I'd say I'm a guy who sometimes plays guitar, bass, or keys when I'm not working or with the family :P