Visokio website     Downloads     Video tutorials     KnowledgeBase  
Tokenising number fields - Visokio Forums
Tokenising number fields
  •     Attiyyah June 27, 2012 7:15AM
    is it possible to tokenise a number field via field manager?
  • 2 Comments
  •     tjbate June 27, 2012 8:31AM
    Attiyyah - Omniscope does not allow tokenisation (multiple values per cell with specified delimiter) of continuous Numeric (Integer or Decimal) or Date/time data types. If you import or create multiple value per cell entries, fro example by aggregating on a field and specifying a 'Unique Values list' aggregation function for one or more fields typed Numeric or Date/Time, Omniscope will re-type the column/field as Text/Category, and you will be able to filter etc. on the individual text values only if you explictly type the field/column as Text/Category and declared it to be tokenised.

    If subsequent parsing of the tokenised delimited text string removes the multiple values per cell condition, and you have the 'Auto-convert data typing' option turned on for the relevant block or stage in the data flow, the single Text values will be re-typed as Numeric. There is also a NUMVAL function that will read a text string that represents a number and re-interpret it as an actual numeric value.
  • Guy_Cuthbert        Guy_Cuthbert June 27, 2012 12:04PM
    Attiyah

    What are you looking to achieve by tokenising a number field? Can you post an example file, with an explanation of your desired output/analysis?
    Atheon Analytics Ltd
    w: www.atheonanalytics.com
    e: guy.cuthbert@atheon.co.uk
    t: +44 8444 145501
    m: +44 7973 550528
    s: guycuthbert

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership