4 Replies Latest reply: Jan 28, 2016 5:07 PM by Danny Selgo RSS

    Multiple Values for SET NullInterpret?

    Danny Selgo

      Hey, I'm trying to figure out how to set multiple values for NullInterpret. The Excel document I'm loading from is using - and . to display null values and I want these to be loaded in as NULL. I'm also wondering if the expression has to be enclosed by single quotes or not ('.', '-'). I would expect it to look like this but I'm not sure if QV wants it this way:

       

      SET NullInterpret = '.', '-';

       

      Please do not link the help text for NullInterpret, I've read it and it does not answer my question.