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

    Quality test - comparing two fields

    Patrick Fenelon

      Hi

       

      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