framework/resources/Functional/values/values_str_4.q

SELECT DISTINCT NULLIF(id, '') FROM (VALUES('1234'),('3456'),(''),('')) tbl(id);