We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# 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.

## Challenge #398: Generating Time Intervals

10 - Fireball

A really neat challenge, thank you, @alexnajm!

I employed the same approach as @AkimasaKajitani  - it seemed the most straightforward using fewer tools.  Thank you, Akimasa!!

ACE Emeritus

I had the basic concept figured out - just took me longer to get to the answer!

Spoiler
9 - Comet

My solution

Spoiler
7 - Meteor

My Solution -- it was good to tinker with the Generate Rows tool, which I don't recall using too often!

12 - Quasar

Shock of shock I nerded out a little. I decided to create an app so you could select your own time card interval.

Spoiler

8 - Asteroid
Spoiler
Solution Attached
8 - Asteroid
Spoiler
8 - Asteroid

I went and created two flows depending on how "missing" times should be handled:

Spoiler
Solution 1 will only generate new rows for data missing between the last provided time and the first provided time. This ignores any times that may have been missing in the middle of the initial dataset.
Solution 2 generates every half hour interval starting from the first provided time and ends at the half hour before the starting time.
Spoiler

16 - Nebula

Solution attached. Embarassing how long this took... (⊙_☉)

9 - Comet

I skipped the input file. Would probably build this as an analytic app with a start/end time input to build output.

Spoiler