Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #110: Think Like a CSE...Reduce the manual inputs!

Highlighted
Alteryx Certified Partner

Good macro practice!

Highlighted
Asteroid

Here is my solution

Highlighted
Asteroid

Somehow it did not get my final file...

Highlighted
Asteroid

Attached is my solution to challenge #110.

Highlighted
Asteroid

Here my solution

Thanks!

Highlighted
Alteryx Certified Partner

My solution :)

Spoiler
challenge_110.PNG
Asteroid
Spoiler
Slightly changed the original macro (added the date selection tools) and created a batch macro from the original flow. Then build a new small workflow:
ch110(2).PNGch110(1).PNG
Highlighted
Spoiler
Simple solution:
I added a condition to swap the Start and End dates in the filter if the user entered them backward (e.g. 7/1/2019 for the start date and 6/1/2019 for the end date).

Also, I assumed that the calendar input was necessary (and we couldn't just generate the list of dates between Start and End using a Generate Rows tool). 

challenge_110_solution_klg_1.PNG

Form:

challenge_110_form.PNG


Batch marco solution (to process each day individually:
I don't really understand the use case for this (why you would need to process each date separately), but here it is!

challenge_110_solution_klg_2.PNG


challenge_110_batch_macro.PNG

Highlighted
Asteroid

I was expecting to make a macro, but I've made an app instead!

I'm not quite sure I understand the bonus question. I did some transposing and dynamic renaming so you get a line of data per date with multiple previous dates (if you type multiple dates into the app). But I wondered if this was a batch macro thing... Looking forward to seeing what others have done!

 

Challenge 110 app image.PNG

Highlighted
Asteroid

Ok updated now to incorporate a batch macro. I'm not sure it adds any value, but good practice in an area where I need it!