Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
I didn't realize you could group by other columns in the Multi-Row Formula tool. That's a great tip. Here's what my solution looked like before I checked out all the comments and everybody else's solutions
Mine is pretty similar to the given solution (notes in spoiler).
Spoiler
I used a separate date parse and multi-row tool (while the solution did this in one tool). Note, the given solution did not sort the records, so it is assuming that records are already pre-sorted by DeviceID, IDFA, and EventFireDate!
Here's my solution:
Spoiler
For some reason the DateTime tool couldn't recognize the EventFireDate field, so I just parsed them separately and joined back on a RecordID field before combining Date and Time.
From there, the Multi-Row tool provided all functionality needed to group and flag the duplicates.
For some reason the DateTime tool couldn't recognize the EventFireDate field, so I just parsed them separately and joined back on a RecordID field before combining Date and Time.
From there, the Multi-Row tool provided all functionality needed to group and flag the duplicates.
One question I had was how would you handle this if you weren't just looking 1 row back, but at the last 'non-duplicate' click, since the number of rows back could be variable. Any suggestions?
