community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #19: Excel Record Locator

Quasar

Fewer tools with another approach - Not convinced it's an improvement over previous solutions but gave me an opportunity to play with changing Excel input.

 

Spoiler
Used SQL to union the required data on input, then a simple crosstab to get the output.

2018-04-09_12-11-13.png
Alteryx Certified Partner

Posting SOlution

Highlighted
Meteoroid

Solution attached.

challenge_19.PNG

 

Spoiler
 
Asteroid

Jet DB query syntax for querying Excel sheets is not intuitive!

 

 

Alteryx Certified Partner

Follow my solution file attached...

Alteryx Certified Partner

Solution attached.

Alteryx Partner
Spoiler
Capture.PNG
Asteroid

Here's my solution :)

 

 

 

Spoiler
Challenge 19 screenshot.jpg

 

Pulsar

Uploading my solution.

 

Workflow.PNGResults.PNG