7|ALTERYX – Goliath Cleaning

[Tyler_Hughes]

Challenge6.yxmd (25.1 KB)

[Parker_Clegg]

Challange7ParkerClegg.yxmd (28.0 KB)

[Tate_Tingey]

Challenge7.yxmd (29.2 KB)

[Brooklyn_Angle]

Here is my solution! This one was a good practice.

[Richard_Robertson]

I suppose it could’ve been done more efficiently, but this worked.

[Mason_Ewing]

Challenge 7.yxmd (27.9 KB)
Good stuff

[Sydni_Hales]

Thanks for the challenge!
GoliathCleaning.yxmd (24.9 KB)

[Mimi_Haddock]

Cleaning.yxmd (30.2 KB)

[Joshua_Barlow]

GoliathCleaningChallenge.yxmd (26.4 KB)

Thanks for the challenge - strangely enough, the hard part for me was getting to select only top 10 or 25 using the select records tool.

[Dakin_Rust]

I enjoyed this one! I chose to use sample at the end but apart from that, I think my solution was very similar to yours.

Challenge7_Workflow.yxmd (30.0 KB)

[Jacob_Smith]

[Michaela_Gracia]

GoliathCleaning.yxmd (26.2 KB)
Fun challenge! It was good for me to understand how to parse better.
GoliathCleaning.yxmd (27.2 KB)

[Hallie_Anderson]

Keep getting more confidence the more I practice!

[Mason_Lewis]

Challenge7WOrkflow.yxmd (30.2 KB)
This was a good challenge. I struggled with getting my text to columns function to work initially but eventually I worked it out!

[baylesma]

I really enjoyed this challenge! Here is what I did.

TechHub practice.yxmd (80.6 KB)

[Aaron_Williams]

[Wyatt_Fronk]

I tried doing something with RegEx initially, but found the Text-to-Columns tool and it was very helpful for this problem, it made it super easy for this dataset. I’d be curious about doing this with data that is less organized. If the separators weren’t there, would RegEx be the best option? Or is there another tool we could use? It would definitely provide for a more challenging parse of the data.
Anyway here’s my results:

[James_Gerstner]

This was a great challenge, I thought it was cool that we could join the transactions table to two other tables at once!
Challenge7_Goliath_JamesGerstner.yxmd (28.0 KB)

[Kyle_Parkinson]

GoliathCleaning.yxmd (30.2 KB)
I felt silly after getting stuck on the data parsing. I forgot that you need to select the data after it has been parsed! Thanks for the challenge!

[Tanner_Wolfe]

New Workflow3.yxmd (26.0 KB)