Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI had to look at the solution because I was lost with the parsing portion and the transpose portion. Going through the answer helped me better understand these new tools because I was able to learn through the interactive lessons provided by Alteryx. I still need a firm grasp of these fundamental tools so that I can better use them alone without having to peak at the solution.
I found this to be just right in terms of how challenging I found the material after going through the first 3 and a half weeks of the ADAPT program.
I am not going to lie though, I had to look at how my fellow community members handled the splitting of Male & female columns. I hadn't considered using the filter tool until I saw it used elsewhere and then I was like "No way. I could have done that!"
I hadn't used the Formula tool so I got to experiment with that tool for this worksheet to extract the Year from the one of the columns.
@ChristineB What can I do to reduce the time it takes to process each time you run the workflow, it took ages everytime I run it, I tried to put the tools inside a container and disabled it, but then the final tool didn't get any data, anyone knows it??
@adrilarotta wrote:@ChristineB What can I do to reduce the time it takes to process each time you run the workflow, it took ages everytime I run it, I tried to put the tools inside a container and disabled it, but then the final tool didn't get any data, anyone knows it??
Hi @adrilarotta,
I also tried to use the Data Cleansing Tool to filter out the Year from the FileName field but I found it to be incredibly slow. I ended up using the Formula Tool and the Substring function which performed much faster. Other than that, our workflows look very similar!
Number 26