Skip to content

Latest commit

 

History

History
33 lines (18 loc) · 977 Bytes

File metadata and controls

33 lines (18 loc) · 977 Bytes

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:

Workflow Snippet