Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Bluemoon
8 - Asteroid

Deceptively tricky...

Spoiler
clipboard_image_0.png
saurabh307singh
8 - Asteroid
 
DuncanT
Alteryx Alumni (Retired)

Here's my challenge 19 solution

SueDonim
8 - Asteroid

 

Spoiler
Solution image.PNG
 

Had to learn a few things about using wildcards but here you go :
- Read in data from both spreadsheets by replacing filename with wildcard
  -- Also had to convert to .xlsx as a security patch on my computer would not allow reading .xls for some reason
- Used multi-row tool to number records (off Excel row number by 1 due to header) for each spreadsheet
- Used two filters to read Row 2 (linenumber 1) from both files and to read Row 8 (linenumber 7) from both files
- Used select tool to isolate and rename specific columns
- Used Join to bring the two together

 
 

Solution above and attached

 

jusdespommes
8 - Asteroid

Definitely a prettier way of doing it than I did it - but done 🙂

 

Spoiler
WeeklyChallenge19.PNG
Si-Pri
8 - Asteroid
 
ArnavS
Alteryx
Alteryx
 
Nicholas_Bowskill
7 - Meteor
 
Assaf_m
11 - Bolide

Solution attached,

 

aazimh
8 - Asteroid

Was worried I took the long way but seems like this is how most went about it.