Weekly Challenges

AndrewHoData · ‎10-06-2022

Took a bit of time to get to the solution but I got there in the end!

Spoiler

JoshuaB · ‎10-07-2022

Updating from my old

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter

Heinrich_Preuß · ‎10-10-2022

Spoiler

agatakrawczyk3 · ‎10-10-2022

😊

longyanChen · ‎10-10-2022

HI

longyanChen · ‎10-10-2022

hi

caitlynmcintyre · ‎10-13-2022

Spoiler

I found this infuriating as it's impossible to do without external data, or hardcoding (a huge no-no) to determine where a street ends and a city begins

I used a lookup sheet of street types and acronyms

I found this infuriating as it's impossible to do without external data, or hardcoding (a huge no-no) to determine where a street ends and a city beginsI used a lookup sheet of street types and acronyms

TungThanhHo · ‎10-24-2022

my solution

willstom24 · ‎10-26-2022

Trickier than I thought it would be but found a solution eventually!

jhonken · ‎10-26-2022

Spoiler

I like the list of potential street name endings - I just did a formula to account for St and Ave variations, but would expand as needed or do a replace those values with blank and then use my same formula?

Weekly Challenges

IDEAS WANTED

Challenge #54: Data Prep Address Parsing