Challenge #42: Inspire Europe '16 Grand Prix (L1)

The link to last week’s challenge (challenge #41) be HERE

Last week in bloody England Alteryx celebrated our European customers at Inspire Europe 2016. In th' tradition 'o th' US Inspire conference thar was a Grand Prix contention whar drivers were challenged to solve business problems usin' the mighty Alteryx tool. 'tis exercise be th' first lap in th' rivalry, recollect that th' peasants only had 10 minutes to answer th' 4 questions in th’ lap so ye may want to the be weary of th’ hour yourself.

Do ye have what it takes? Th' correct solution gunna earn ye some lovely booty:

T' upload yer solution - take a wee little screenshot an' don't be spoilin it fer th' rest of us scurvy pirates. Put it in a Spoiler Tag and give ye a hearty YARRR!

A solvin tactic has been posted - but we wanna see yer bloody pirate way!

challenge_42_start_file.yxzp

challenge_42_solution.yxzp

Join

Preparation

Data Analysis

Intermediate

Core

Transform

Accepted answers

All comments

Philip

Awesome! This fun, lap 1 done.

TaraM

@Philip wrote:
Awesome! This fun, lap 1 done.

Ay @Philip - let me translate fer ya

"Full 'o awe! 'tis a ruckas, lap 1 done."

If ye be wantin th' booty ye best be curlin yer tongue with some scurvy pirate speak! We also need to be seein' yer solvin' tactics!

http://postlikeapirate.com/

will help all ye land lubbers!

Philip

Blimey! I not be talkin' pirate-like. Excuse me twisted turn of phrase. 'Tis a sign I be needin' more rum!

I walked the plank to make this witches brew of solution. Where might I be a postin' me solution to see if I upheld the scurvy pirate's code for crossin' swords with this here shark bait data. There be no place to take onboard an attachment.

TaraM

Curse ye! Rob that grungy botswain!

Just upload a screenshot of yer workflow and put it in a spoiler tag.

Philip

Here be me solution to ye data inquiry.

Spoiler

Th' answer to th' enumerated inquiries:

1. 18,886

2. 1,397

3. 4,004

4. 6,418

MattD

Ahoy, Philip!

Looks jolly to th' cap'n - now heartly enjoy ye lovely booty!

danielbrun2

This is great! looking forward to the next adventure! Gunna ye message a solution?

brianprestidge

Nice slick little weekly challenge to finish off the week! Heres my solution:

Spoiler

SPOILER

My Answers:
18886
1397
4004
6418

TaraM

YAR! @danielbrun2 - stick yer solution under a spoiler fer the pirate booty!

brianprestidge

Thank ye fer me scurvy pirate badge

JohnJPS

aR! That webby pirate jibber jabber place be forebidden within our blazin' walls of fire! So, ye scurvy scallowags, I be typin' this all on me own. Beneath th' spoiler ye'll find th' swashbucklin' I took took to blastin' th' unholy scourge of filth from me treasued pile o' data.

Spoiler

SeanAdams

Aargh - methinks Oi spot a solution yonder, me matey

challenge_42_SeanSolution.yxmd

NicoleJohnson

My solution. I think I have realized I would do these challenges about 50 times faster if I wasn't so OCD about my tools all lining up perfectly on the canvas. ARGH.

Spoiler

challenge_42_NicoleJohnson.yxmd

estherb47

Spoiler

challenge_42_EHB_solution.yxmd

LordNeilLord

Yarrrrr

Spoiler

challenge_42_LNL.yxzp

nick_ceneviva

Solution attached

challenge_42_Ceneviva.yxmd

jamielaird

'Ere's me solution, mateys

Spoiler

challenge_42_JL.yxmd

patrick_digan

'tis a bit late

Spoiler

challenge_42_start_file.yxmd

Natasha

Looks like the start file doesn't include additional questions anymore

Spoiler

challenge_42_Natasha.yxmd

JoshKushner

Now this was pretty cool with no output to compare to

challenge_42_start_file.yxzp

samN

avast ye land lovers, make way

Spoiler

challenge_42.yxmd

ggruccio

Love learning shortcuts to open multiple tabs/files.

challenge_42_gg_finish.yxzp

philipmannering

Solution attached.

Spoiler

challenge_42 - Grand Prix 2016 L1.yxzp

jasperlch

Solution attached.

challenge_42_JL.yxzp

msicak

argh that blasted dynamic input that I did not know about before! A great trick, I had to use brute force and barely made it with 2 seconds to "spare".