Cloud Quest #1: Preparing Delimited Data

[bradshaw]

This should do it!

Spoiler

[andrewgu]

What a surprise to see a new category for cloud! Solved during the weekly challenge hour in Australia, using only brushing suggestions!

[nwaters]

Spoiler

Very glad to see Cloud Quests on here :-). Here is my solution offering ...

[SylviaP]

Hey everyone!

Just a heads-up!

In order to be automatically assigned badges, you need to upload a screenshot of the solution. We can perfectly check the solution by looking at your spoiler images, but unfortunately, for the badges, the system requires an attachment (it recognizes an attachment, but not a spoiler).

You have the option to easily edit your post and include an image attachment. 😊

Thank you!

[Treyson]

Super excited for these quests! I used a few more tools than most of these posts, but I went through it in my head like how I use this weekly challenge (#2) in trainings.

Spoiler

 

[NodToNothing]

Hmm....it didn't actually say to format the data as a date and int that I noticed, so as a previous dev who knows better than to add where it's not asked for without asking first, I didn't, although that's easy enough with a select and datetime tool at the end as needed. I do realize that internal ' and " might be an issue with my solution although I also followed the rule, "Know Thy Data".

Spoiler

[biancang]

Things are in new places but the tools feel the same!

[Shelbey]

[SGolnik]

I love the idea of these Quests!!! 

Spoiler

[serranoX]

1st Cloud Quest Completed. Could be done by Regex with less steps. Here i'm using Data Cleansing tools and Date Custom Formats.