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
A solution to last week’s challenge can be found here.
This challenge was submitted by our ACE Calvin Tang, @caltang . Thank you, Tang for your submission!
Organizations often deal with poorly formatted financial data stored in fixed-width flat files, which creates inconsistencies and makes analysis difficult. In this challenge, you will work on cleaning and standardizing transaction records containing account numbers, customer names, transaction types, and amounts. The goal is to improve data quality, enable efficient management, and support better financial decision-making.
Develop a workflow in Alteryx to:
- Clean and format the data, then calculate the total for deposits and withdrawals.
- Use the Interactive Chart tool to create a graph that displays the total deposits and withdrawals.
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
Download Start File
Source: Dataset generated by AI (POE).
Thanks for featuring my challenge Community team!
Actually, the idea of the challenge was also to include how to input the .txt file as the starting point rather than having the .txt file already there. Then it will allow end users and community members to practice how to use the fixed width delimited file.
The idea behind this challenge is based on that premise - because it is not something done often unless you are in an org that still uses those type of files.
Happy to contribute :D
Fun challenge. @caltang, configuring the text file itself certainly did add an extra layer of difficulty; I'll be honest, it took me a little while to figure out what to do there😄
I did the aggregation part of the challenge first, then went back to try and configure the text file myself. I had already seen I needed to use Flat ASCII format, but not sure I would have got an answer without knowing that. Once I selected the Flat ASCII format, I then configured the column sizes in the pop-up window by simply clicking where I wanted the red lines/table to be delimited. I got the following configuration:
Good challenge, as I agree it's good to use the fixed width when you use a text file. There are similarities to Excel with using the width.
