I am trying to filter out a bad record when running Query Studio. Is there anyway to setup a "not equal to" filter? (ie bundle NE 38002740)
Also I tried to filter out the bad data (2004 record) by selecting only 2007 data however the query still gives an error "A freeform number is invalid". Does this make sense or is it just a coincidence?
yes, first set up the filter you want as a not (not a must but easier to explain if you do this first) go to edit data (in your menu) then click Combine Filter. then select the filter you created and click "apply NOT"