Visokio website     Downloads     Video tutorials     KnowledgeBase  
"Unknown" in text field registering as Null value - Visokio Forums
"Unknown" in text field registering as Null value
  •     si42 February 18, 2011 7:08AM
    When we import a csv into Omni where there is the string 'unknown' somewhere in a record, Omni registers a null value. I'm not sure if this is actually a bug if it's intentional, is there a way round this?
  • 1 Comment
  •     chris February 18, 2011 7:13AM
    Hi,

    Thanks for your question. You need to uncheck the 'Auto-convert to empty' option when importing the CSV file. This is available in Omniscope 2.6.

    The 'Auto-convert to empty' option appears in the 'Parsing' section of the import configuration panel and automatically converts several different values to null (n/a, unknown, not known etc) when they are encountered.
Add a Comment

Welcome!

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

Sign In Apply for Membership

Categories