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

With spatial expressions as an alternative to the find nearest tool.

Screenshot 2024-04-22 114219.png

It was definitely a challenge, as spatial work is not common in my workflows. Thanks for the practice.

JSON parse makes life easier. Use the column definitions in the container to also make life easier.

Happy Earth Day

It is a fun challenge.

And as noticed before the "Maximum Distances" field in the "Find Nearest" tool can not accept manual input anymore. 😬

Re: Find Nearest tool in 2023.2 - Alteryx Community

@Qiu the XML of the find nearest tool can be updated to use it as it was prior to the 2023.2 software release.

@AGilbert
This is good to know. Thank you very much.

Happy Earth day! 🌳🌻

My solution.

Workflow

Expression in Formula tool
Irvine HQ =
ST_CreatePoint(
ToNumber(REGEX_Replace([Irvine HQ (lat, long)], "^.*, ", "")),
ToNumber(REGEX_Replace([Irvine HQ (lat, long)], ",.*", ""))
)

WorkflowExpression in Formula toolIrvine HQ = ST_CreatePoint(ToNumber(REGEX_Replace([Irvine HQ (lat, long)], "^.*, ", "")),ToNumber(REGEX_Replace([Irvine HQ (lat, long)], ",.*", "")))

curated machine learning resources