Visokio website     Downloads     Video tutorials     KnowledgeBase  
Import: Reading in value "unknown"? - Visokio Forums
Import: Reading in value "unknown"?
  •     Phillipa September 17, 2014 6:22AM
    Hi,

    We are feeding data into Omniscope from an excel file.

    Some of the fields have options- yes/no/unknown

    For some reason when we input the data the answers "unknown" are being deleted and treated as not answered so we cannot see which fields are really empty and which answered with "unknown".

    Is there some kind of setting that we can change so that we get the answer Unknown in the Omnisope file?

    Thanks
    Phillipa
  • 2 Comments
  •     chris September 17, 2014 6:51AM
    Hi Phillipa,

    Thanks for the question.

    By default Omniscope removes "Empty" keywords from all file sources. Empty keywords include "Not known", "N/A" and "Unknown".

    You can turn this off be un-checking the "Auto-convert to empty" option in the block (highlighted below).

    image
  •     Phillipa September 17, 2014 7:51AM
    Dear Chris,

    Thanks a lot.

    If only all problems were so easily solved.....

    Phillipa
This discussion has been closed.
← All Discussions

Welcome!

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

Sign In Apply for Membership

Tagged