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.

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 #46: Formatting a Date from an Integer

Tberney
8 - Asteroid
Always fun trying to balance clarity and apparent efficiency.
Question - is there any performance difference between a single formula tool with multiple steps vs the same # of individual formula tools? I would expect the difference to be small and in favor of a single tool
TMB
MikeLR
8 - Asteroid

 I'm not sure if there will be much of a difference in performance but here's a way of finding out. I have found it really useful for improving my workflows.

https://community.alteryx.com/t5/Alteryx-Designer/Performance-Profiling-in-v10/td-p/3771 

Tberney
8 - Asteroid

New to me, but I will definitely play with it

Lucatelli
8 - Asteroid

Please find attached my proposed solution.

Harkamal
8 - Asteroid

here is my solution

jsenk
7 - Meteor

Solution

pawanmalik
8 - Asteroid

My solution for this challenge.

FlorianC
Alteryx
Alteryx

The switch statement is great to manage multiple cases like this.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
gguedes1
8 - Asteroid

Completed Challenge

KevinHarrison
8 - Asteroid
Spoiler
KevinHarrison_0-1595883744113.png

 

I like to mess with Regex tools.