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

Fun one!! Needed only a few tools to accomplish, and I left the county names in. Dynamic tools are wonderful

Spoiler

And another...

I began by creating the titles from the "Fields" input, which is a combination of the Category, Subcategory and Description, I then used Dynamic Rename to take the new column from the Fields input and replace the Name column from the data. I then used Dynamic Select to to remove the non-title fields.

I began by creating the titles from the "Fields" input, which is a combination of the Category, Subcategory and Description, I then used Dynamic Rename to take the new column from the Fields input and replace the Name column from the data. I then used Dynamic Select to to remove the non-title fields.

Great use case for the Dynamic tools!

Weekly Challenge 64.png

Here's my solution. Not sure why the posted solution doesn't include a location field (seems important!) so I've kept that in.

Solution Attached! Had never used dynamic select before.

Created a long workflow only to realize that crosstab alphabetizes columns and then realized that a dynamic rename and select make it pretty simple.

Created a long workflow only to realize that crosstab alphabetizes columns and then realized that a dynamic rename and select make it pretty simple.

Another one down

Another use case for transpose and crosstab

Solution attached.

Definitely not the best. Looks like everyone nailed it with a dynamic select. Solution attached.

challenge_64 - Snip.PNG

Solution attached.

curated machine learning resources

Join the tampa, florida User Group