Tuesday, February 13, 2024

Alteryx Cloud Quest 1 [includes Spoiler]

I've done a few of the challenges using our product - the weekly challenges and the Advent of Code leveraging our framework as the "language" of choice.  It's tricky if your brain gravitates toward Python solutions.  The point of Alteryx isn't to replace your knowledge of Python or some other language.  The point is that you're a business analyst or otherwise who might not know a language in the first place.

There's a new set of challenges - Cloud Quest - at the Alteryx Community site.  Thought I'd give them a try.  https://community.alteryx.com/t5/Cloud-Quests/Quest-1-Preparing-Delimited-Data/m-p/1240435#M26.  I tried not to use the basic Swiss Army knife that is the Formula Tool [my go to] and I didn't format the datatypes given the exercise didn't actually ask for that to be done, only implied it [and as a former dev, don't make assumptions without checking with the owner/product unless it's for your own use].


In the world of data processing, text files often come with delimiters like quotes to manage strings that contain special characters or additional delimiters. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple delimiter types.


In this quest, you have a CSV dataset with two different delimiters: double quotes and single quotes, and they surround different data types. Use Designer Cloud to strip these delimiters, as they are superfluous and need to be removed to clean and format the data correctly.


Begin your workflow with the provided dataset:

Row 1: "Mary had a little lamb whose fleece was white as snow",123,'16-JUN-01'

Row 2: "I do not like green eggs and ham",456,'25-DEC-10'


No comments: