• v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Filter column data using the OR selector
NEXT
Group data

Searching data / Building a query / Build a query in the search window / Create columns

Download as PDF

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:

    StandardShows only the predefined operations in Devo.
    CustomShows only the custom operations based on lookup tables.
    AllShows all the available operations.

    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.

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.

You can select the default option in your User preferences, and Admin users can do the same for all the users in the domain in their Domain preferences.

Download as PDF

PREVIOUS
Filter column data using the OR selector
NEXT
Group data

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport