Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)
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?
