Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

Challenge #192: Crane Leasing

lucysinclair62
8 - Asteroid

My solution below:

Spoiler
lucysinclair62_0-1673975943560.png

 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Generate Rows coming in to save the day

Spoiler
BS_THE_ANALYST_0-1674415628357.png

 

All the best,
BS

LinkedIN

Bulien
dougbaron
8 - Asteroid
Spoiler
dougbaron_0-1674873204294.png

 

StellaBon
11 - Bolide
Spoiler
StellaBon_0-1675446430400.png

 

Good practice for generate rows using dates

caltang
17 - Castor
17 - Castor

Got it done!

 

Spoiler
caltang_0-1675659175293.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
François_Rs
8 - Asteroid
Spoiler
Spoiler
Franois_Rs_0-1675941174830.png

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1676044311116.png

 

subhajit843
8 - Asteroid

Here it is

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution:

Shahbaz_analyst
8 - Asteroid
Spoiler
Shahbaz_analyst_0-1677768389800.png

 

Interesting thing I learnt about the generate rows tool in this challenge. If your newly created field is a datetime type and your end date field is just a date type the generated rows won't include the last date even if your expression says new field <= end date field. I assume this is to do with the time component not lining up with the end date but it took me a while to figure out why I was getting different amounts of rows using the generate rows function when i updated a field vs creating a new field.