You can create new columns in your data tables based on other data already in the table. For example, apply a geolocation operation on an existing IP address column to create a new column that identifies the country. Devo comes full of predefined standard operations to help you create new columns but you can also create custom operations, based on lookup tables, suited to your organization's particular information. See Data enrichment for information about creating custom lookup tables in Devo.
- Select the icon in the query window toolbar and the Operations Over Columns window appears with the Create column option selected.
Enter a Column Name and choose the required operation type in the Operation drop-down list. You can filter the list of available operations using the buttons next to the drop-down:
Standard Shows only the predefined operations in Devo. Custom Shows only the custom operations based on lookup tables. All Shows all the available operations.
Note that if you have grouped or aggregated your data, you will only have access to standard operations, and the buttons will not be visible.
- Select the arguments for the operation. Depending on the operation type selected, you will be prompted to select a set of specific arguments.
You can select columns or also enter free text clicking the icon, as is sometimes required for an operation. For example, you might want to create a column that displays only those transfer times greater than 200 seconds.
- Click Create column when you're done. The new column will display the results of the operation defined.
Case sensitivity selector
Some operations have a case sensitive and a case insensitive version, for example, Contains - case insensitive (weakhas) and Contains (has, ->). Use the Case sensitivity buttons in the window to display only the sensitive or insensitive versions of these operations, or choose all to show both versions. Operations that don't have a sensitive and insensitive version will be visible no matter the option selected.
The following articles define all the expressions and functions available when creating a new column.