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 an operation type in the Operation dropdown. 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.

   Naming columns

   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:

   `2my_column`

   This is automatically done if your using the interface, so you don't need to enter the symbols.

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.