Challenge #2: Preparing Delimited Data

[aeday]

My Solution

[mara_plc]

Done!

[Leonardo-Ceballos]

Hi, here's my solution.

Spoiler

Spoiler

 

[monik]

bonsoir, mon premier exercice, merci bcp!

[JessicaEP]

Completed!

[Shubhanker]

done

[erica_sch]

Spoiler

SPOILER

[zaldiz]

Completed

[Shivraj96]

Here's my answer file, drop me a reply in case of any queries.

[Vsrivastava]

Input:

Output:

Workflow:

Steps followed:
1.) Input tool to get raw data
2.) Parsing tool to extract different delimiters data in columns
3.) Select tool to choose right columns for output
4.) Type conversion tool to convert string to date and join required columns horizontally using multi join tool
5.) Browse tool to get final output