The My Wrangles page of the Data Wrangles add-in is where Data Wranglers spend most of their time, it is where all of their DIY and Bespoke Wrangles can be found. DIY Wrangles are made by the user and can be edited. Bespoke Wrangles are custom Wrangles made by the Wrangle Works team which cannot be edited by the user. Both can be shared using permissions. Both can be Classify, Extract, or Standardize Wrangles.
¶ Types of Custom Wrangles
- Classify Predict which categories items belong to
- Extract Identify and extract meaningful information from unstructured text
- Standardize Wrangles to Standardize text data
- Map Map columns from one table/sheet to another where the columns names have been standardized
- Lookup Save data to be looked up later as a Wrangle or in a recipe
¶ Creating DIY Wrangles
The Data Wrangles Excel add-in makes it very easy to create your own Wrangle. Simply open the Data Wrangles tool bar and click on the "My Wrangles" button, this will open the Wrangles Task Pane. From here, click the button which pertains to the type of Wrangle (Classify, Extract or Standardize) you wish to create then click the + sign at the top right corner of the Task Pane. This will create a new sheet where the training data will need to be placed. Once the training data is all filled in and the model has been named, click the submit button to train your custom DIY Wrangle. Your DIY Wrangle is now ready for use from the Wrangles Task Pane.
Note: If there are spaces before or after the text to find, the wrangle will not return an output. If a front/back space is needed in the extraction, the best approach is to use regex.
Do not be worried if you have made an error and wish to change your training data, DIY Wrangles can always be retrained by clicking the edit button in the Wrangles Task Pane.
See Wrangles In Depth Example (Excel) for another look at how to build a DIY Wrangle.
¶ Referencing Your Wrangle in a Recipe
In order to use your wrangle in recipe, you will need to reference it using its model id. You can copy your wrangle's model id to your clipboard by either double clicking on the wrangle in the task pane, hovering over the wrangle then clicking the copy button in the pop-up window or by opening the "Edit Wrangle Details" panel (which is accessed with a single click of the wrangle) then clicking the copy button next to the model id at the top.
¶ Permissions
With permissions, you can allow others access to your Wrangles. There are three levels of permissions, see below for more information.
¶ Available Roles
| Role | Access |
|---|---|
| User | The User tier allows others access to use the Wrangle but they cannot access the training data or grant others access to the Wrangle. |
| Editor | In addition to being able to run a wrangle, Editors can also view and update the training data. Editors do not have access to a Wrangle's permission and therefore cannot grant others access. |
| Admin | Admins have full control over a Wrangle. They can edit meta and training data as well as access permissions to grant or restrict access from others. |
Roles can be searched on by including "role:" before the role in the search bar. (ie "role:admin")
¶ Removing Users From a Wrangle
Admins can remove users (actual users, not just the user role) from wrangles by clicking the "Remove User" button next to the user's name in permissions. Admins can remove all users, including other admins.
¶ Organizations
Organizations allow users that belong to an organization to see other users belonging to the same organization and to share wrangles/recipes with them by name or with the organization as a whole.
Users who wish to share a wrangle with an organization which they are not a part of themselves can do so by typing orgname@org. It is not case sensitive, but users do need to know the organization's name which is typically a single word abbreviated version. For example, wrangleworks@org.
Like roles, organizations can also be used to search by including "org:" before the organization in the search bar. (ie "org:wrangleworks")
¶ Versions
Versions allow users to restore previous versions of the wrangle. Versions store the last 30 iterations, or every iteration for the prior week. So, for instance, a wrangle has had 40 iterations in one week those 40 will be store for one week then the first 10 (oldest versions) will be dropped leaving the 30 most current iterations.
To access versions, simply click on the reverse clock icon in the Update panel. Below shows an example of versions in a classify wrangle.
¶ Organizing Wrangles
Tags and descriptions can be added to each wrangle by clicking on the wrangle. Tags are searchable (by clicking the tag itself or by using the search bar) and appear below the name of the wrangle. Descriptions are not searchable and will appear in a pop-up if you hover your cursor over the wrangle. The gif below shows how to add tags and descriptions:
¶ Hide
Wrangles can be hidden from your task pane by using the Hide setting. To show hidden wrangles, toggle the setting on in the main settings.
