Search

Close

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

My solution below:

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

Here is my solution

Screenshot 2023-12-04 152759.png

solution attached

Screenshot Challenge #19.png

Good use case for Tile tool.

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.

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

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!

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!