Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
SOLVED
Piece of cake! Couldn't imagine doing this one on stage though! Gosh I'd be so nervous. I'd much rather uhm do a live stream on Twitch (!!!)
Also! If I solve one more then I'd have done 15 ... level up with a new badge!
Spoiler
1. Clean
Needs two DateTime tools.
I like to use RegEx tool instead of the Formula tool, but my Regex for this was:
\W.(\d*.\d*)
which slices out the $ value in to a Double format column.
2. Solve
Then it's just a case of a Join
and a Field Summary
BTW if you use a Join Mutliple, I think it outputs a full outer join normally anyway.
For this one I'm using a regular Join - always (always!) check the results of the Left output tab and the Right output tab just to make sure you don't have any unmatched items.
This is a 1-2 step, the combo of (1) Clean it! and (2) Solve it!
1. Clean
Needs two DateTime tools.
I like to use RegEx tool instead of the Formula tool, but my Regex for this was:
\W.(\d*.\d*)
which slices out the $ value in to a Double format column.
2. Solve
Then it's just a case of a Join
and a Field Summary
BTW if you use a Join Mutliple, I think it outputs a full outer join normally anyway.
For this one I'm using a regular Join - always (always!) check the results of the Left output tab and the Right output tab just to make sure you don't have any unmatched items.
