I am trying to improve load times and have been updating code to allow for efficiency. one of the changes i was making is in regards to the Exists() function. my current script looks like this:
FROM $(WorkflowPath)\test.QVD (qvd)
where test_SYSTEM_CD <> 'CWF';
and this works, but when I change "where test_SYSTEM_CD <> 'CWF';" to "where not exists(test_SYSTEM_CD,'CWF');" it returns 0 results. this would probably only save me a few seconds, but i am more interested in why this wouldn't work.
Just as an FYI, it does work with a string like 'CWF' as long as the field is included in the load statement. With other functions and fields used in the where statement you don't need to include it so I wasn't expecting it to be any different.