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.
As a work around, you could use REPLACE() functions for your multiple symbols to replace all of them with a consistent character, like '-', and then use that single character in the NullInterpret variable.