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 #19: Excel Record Locator

olivier_newman
8 - Asteroid

Challenge 19 

gcampbell249
7 - Meteor
Spoiler
Alteryx 19.png
Rob-Silk
8 - Asteroid

My solution below:

I added an extra Text Input tool to make the choice of row number for required column slightly more dynamic

 

Spoiler
challenge_19_RS_screencap.PNG
Myles_Stevenson
8 - Asteroid

Here is my solution 

Spoiler
Screenshot 2023-12-04 152759.png

AthollJ
7 - Meteor

solution attached

caitlynmcintyre
9 - Comet
Spoiler
19.png
mihaimazareanu
6 - Meteoroid

 

Spoiler
Screenshot Challenge #19.png

asultanov
8 - Asteroid

Good use case for Tile tool.

Zhengyi
8 - Asteroid

Nice challenge! Somehow my Alteryx doesn't support input .xls format so I have to change them to the .xlsx format in order to impot them all.

KristenB
7 - Meteor

I did this one a whole heck of a lot differently than most others, but it also seems relatively straightforward too.

 

Spoiler
I used a directory apphended with the sheet and cell I wanted to pull, configured the dynamic input to replace the file name, sheet name, and pass the sheet name through. Then CrossTab'ed, renamed columns, and done!
Snag_45543ae.png
Snag_4554f56.png
Snag_4559028.png