3 Replies Latest reply: Jun 10, 2015 11:38 AM by Patrick Fenelon RSS

    Quality test - comparing two fields

    Patrick Fenelon



      I've browsed the forums but couldn't find my answer.


      I have a set of data (set a) with Post Codes, and another set of data (set b)  with all UK Post Codes.


      I want to quality check that the Post Codes in set a appear in set b, and ideally produce a field called 'PostCodeValid' with the options of either 'Y' or 'N'.


      Many Thanks