Selection on a HASH file.

[admin]

Hello,

I am having trouble using the select criteria on a HASHed File stage. When my criteria is based on a column that I have hardcoded in an earlier transformer stage, it works as expected. But I have another column, allergy_desc, that is an MV field. I have successfully normalized the data the way I want, but I cant seem to use the SELECT criteria on that column.

My select allergy_desc gives the "Data Source Empty" message.
while allergy_desc = gives me back all my data,
including lots of allergy_desc info...

That really seems backwards. What I really want to accomplish is to pull back
only those records where the value(or subvalue?) of allergy_desc is NOT null or empty.

Please let me know if you can help or need further clarification.

Much thanks in advance,
Jill