You can create new columns in your data tables based on other data already present. For example, apply a geolocation operation to an existing IP address column to create a new column that identifies the country. Devo comes with 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 Create column 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 an 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.
Operation buttons missing
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.
If you are building your query in the Query editor and the name of your column starts with a number or symbol, you must scape it between `` like in this example:
This is automatically done if your using the interface, so you don't need to enter the symbols.
- 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 by clicking the icon, as is sometimes required for an operation.
- 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.