Yes. Sorry I had a bad copy/paste. I have 'set NULLASVALUE='<NULL>';' in a group of set statements in the first load sheet I have. I've also tried placing it this in each load sheet as follows:
[Gift Alt Group Code],
[Gift Mission Flag]
FROM [lib://QVD - Donor Perfect/DonorPerfect.GiftUDF.QVD]
According to Help...
You need 2 lines, assuming you are replacing null GiftID's
Personally, I go about it by setting a flag and using that to select.
If(IsNull(GiftID),1,0) As NullGiftID;
Thank you, Antonio. The second solution worked for me. I still could not get the NullAsValue or NullValue options to work. I was using both lines cited multiple times in this thread. A flag of just null wasn't appropriate in this case because I wanted to select both null and other values for the field.
I did figure out that I can filter on the <null> in the table itself but not when I used a filter pane. In the filter pane no option for "<null>" appeared after using the length/trim statement.
Thank you to everyone who offered help.