Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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
14 - Magnetar

Generate Rows coming in to save the day

Spoiler
BS_THE_ANALYST_0-1674415628357.png

 

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.