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 #86: Create a Macro that Generates Past Dates

JoeM
Alteryx Alumni (Retired)

Welcome @elamm43!

EmanueleE
8 - Asteroid

Hi guys!!! This is my solution!!!

 

 

Spoiler
app1.PNGmacro1.PNG

 

 

ankitthescorpion
5 - Atom

This is my first attempt at an Alteryx Weekly Challenge. Please find attached my two macros for the weekly challenge. I have completed both the bonus challenges as well.

 

File 1 Non Encrypted and File 2 which is encrypted

 

Niklas
8 - Asteroid

Attached packaged canvas with post solutions

 

Spoiler
C_86.PNG

 

JoeM
Alteryx Alumni (Retired)

Solution posted! After looking through this week's submissions, I found my solution to do two things that nobody else's did (albeit no more correct than anyone else's).  

1) For the first time in awhile, I used this as an opportunity to use an Action tool that did not serve as an intermediary to the workflow and an interface tool. It merely existed to generate today's date in my Text Input tool. 

2) I used the TS Filler tool. If you struggle with using generate rows, it's a nice easy tool to use.

JonM
8 - Asteroid

Nice little challenge, have done something similar before but did not consider making it a Macro.

estherb47
15 - Aurora
15 - Aurora

Welcome @elamm43!!

vishalgupta
7 - Meteor
 
jdunkerley79
ACE Emeritus
ACE Emeritus

Nice challenge

Spoiler
2017-10-04_14-19-02.jpg
Claje
14 - Magnetar

@jdunkerley79

 

Spoiler
That Generate Rows formula is beautiful!  I didn't even think of skipping weekends directly in step 1.