Challenge-02

Challenge - 02 : Preparing Delimited Data

Problem Statement :

In the input file, there are two different delimiters (double quotes, single quotes) and they surround different data types.

Strip out the delimiters as superfluous and format the data in a nice way.

Here is the weekly challenge link in the Alteryx community: Challenge #2: Preparing Delimited Data

Concept & Highlights Covered :

This challenge covers the following concepts:

• Data Preparation

The Alteryx tools and techniques that can be used to solve this challenge are as follows:

• Prepare
• Parse

The proficiency level required to solve the challenge is : Basic

Solution :

Here is the snippet of the workflow that achieves the required result: