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

sann0638
8 - Asteroid

Just uploading ones that I have had a go at. Thanks for putting these together!

KevinW
8 - Asteroid

I disagree with the request to "check the box for First Row Contains Data" - excel files have their headers in the first row, so there is not data there.  the only thing this changed for me is I am dealing with the 1st and 7th rows of data instead of 2nd and 8th.

 

Spoiler
19.JPG
JoeS
Alteryx
Alteryx

Wow, seems like I should read the notes in the comment box as well as the community article, didnt see it was just sheet one and was assuming it was each sheet (AKA 1, 2 and 3)

Then I read it was only sheet one......

 

Spoiler
Workflow.png
Alekh
9 - Comet

Did it differently

Spoiler
19..png

 

 

 

 

niapope
6 - Meteoroid

My solution

AntonioGonzales
8 - Asteroid

Solved!

Good exercise!

Spoiler
19.png

Cheers!

 

msicak
8 - Asteroid
Spoiler
ch19.png
KaneG
Alteryx Alumni (Retired)

I went with a lazy route through multiple Sample Tools just for fun

 

Spoiler
Challenge19.png
Paul-Evans
9 - Comet

Here's my solution:

Spoiler
19.JPG
lichunyan8825
5 - Atom

Here is my solution