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.
- 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.
The following articles define all the expressions and functions available when creating a new column.