Create columns

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.  

1. Select the Create column icon in the query window toolbar and the Operations Over Columns window appears with the Create column option selected.
   
   

2. 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.

3. 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. 
4. Click Create column when you're done. The new column will display the results of the operation defined.