Now that Gallery has been on Community for a little over a year, it seems like a good time to look back at some interesting macros, tools, and packages! Keep reading to see the wide variety of useful Gallery uploads (and note, for this blog, I am excluding Alteryx-created items and only looking at user submissions). Who knows, maybe one of them can solve the use case you’ve been stuck on or help speed up your workflow development time.
![MeganDibble_0-1674250942581.png MeganDibble_0-1674250942581.png](https://community.alteryx.com/t5/image/serverpage/image-id/282537i119DF1BD35827497/image-dimensions/737x175?v=v2)
This data cleanse tool provides you with more functionality and a faster cleanup.
![MeganDibble_1-1674250942612.png MeganDibble_1-1674250942612.png](https://community.alteryx.com/t5/image/serverpage/image-id/282534i35770257EC67B02F/image-dimensions/660x264?v=v2)
The Jira iterative macro obtains Jira data in a transactional record-based format. The macro connects to Jira through their API, establishing a customizable query that will iteratively retrieve records from a Jira project. The workflow parses and processes the JSON data into a consumable format for further analysis. You can find detailed documentation in this post.
![MeganDibble_2-1674250942639.png MeganDibble_2-1674250942639.png](https://community.alteryx.com/t5/image/serverpage/image-id/282536i3B0B817D852E196E/image-dimensions/563x181?v=v2)
This macro from TravelTime can be used to convert street addresses into lat-long coordinates, and vice versa. Enables addresses to be added to the map as points for further analysis. Download a free API key to get started.
![MeganDibble_3-1674250942666.png MeganDibble_3-1674250942666.png](https://community.alteryx.com/t5/image/serverpage/image-id/282539i2B16132658C93635/image-dimensions/687x166?v=v2)
If you have an Alteryx Private Gallery setup, you can use your key and secret to hit the various api endpoints with this macro. See this post and this post which have details on how to obtain your key and secret as well as background on how the macro was built.
![MeganDibble_4-1674250942704.png MeganDibble_4-1674250942704.png](https://community.alteryx.com/t5/image/serverpage/image-id/282541i6CE2D30E2C8074DC/image-size/large?v=v2&px=999)
This macro enables you to detect outlier data points by a variety of methods. You can identify, delete or modify the points. The macro is in beta and any feedback about the functions or how the macro works would be appreciated.
![MeganDibble_5-1674250942730.png MeganDibble_5-1674250942730.png](https://community.alteryx.com/t5/image/serverpage/image-id/282540i09163D4171E59895/image-size/large?v=v2&px=999)
This macro will generate a hierarchy table that displays all the parents of a given child field, based on an input that provides a list of child-parent relationships. For a blog article describing the macro in detail, please refer to this article: Building a Hierarchy with Kevin Bacon.
![MeganDibble_6-1674250942750.png MeganDibble_6-1674250942750.png](https://community.alteryx.com/t5/image/serverpage/image-id/282542i6BBCF46D49181578/image-dimensions/580x162?v=v2)
This tool allows you to pass a password and file location of a password protected Excel file and input its data into Alteryx. Once installed, it will appear in the In/Out tool group.
![MeganDibble_7-1674250942772.png MeganDibble_7-1674250942772.png](https://community.alteryx.com/t5/image/serverpage/image-id/282543i811224764E6D0F81/image-dimensions/808x157?v=v2)
This macro allows users to easily output their workflow to multiple Excel files or sheets, removing the need for creating a custom file path each time either of these options are required.
![MeganDibble_8-1674250942794.png MeganDibble_8-1674250942794.png](https://community.alteryx.com/t5/image/serverpage/image-id/282544i4D26798CB928D1C8/image-dimensions/846x147?v=v2)
A simple One-Hot Encoder tool allowing for quick and easy encoding of your categorical variables.
![MeganDibble_9-1674250942824.png MeganDibble_9-1674250942824.png](https://community.alteryx.com/t5/image/serverpage/image-id/282545i324B63E1B7844B8B/image-dimensions/889x178?v=v2)
This Macro is intended to allow you to count the business days between 2 dates for each row in your dataset. It takes into account your organization’s and your country’s holidays. The package contains the macro itself and a demo workflow for easier use.
There you have it—10 great tools to try out in your Alteryx workflows. A big thanks to the community members tagged above for sharing their knowledge and skills with everyone.
Is there something that you downloaded from Gallery that has made your workflow development easier? Share it in the comments below!