topic Re: Quality test - comparing two fields in QlikView

Quality test - comparing two fields

Wed, 10 Jun 2015 15:01:44 GMT

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

Re: Quality test - comparing two fields

swuehl — Wed, 10 Jun 2015 15:03:57 GMT

MAP:

MAPPING LOAD

Postcode, 'Y' as F2

FROM AllUKPostcodeTable;

TABLE:

LOAD

Postcode,

applymap('MAP',Postcode, 'N') as Valid,

FROM YourTable;

Re: Quality test - comparing two fields

alexandros17 — Wed, 10 Jun 2015 15:06:16 GMT

If the table with all Post codes is "Tab1" and the other table is Tab2 then, supposing that the post code in both tables is "myPostCode" then

MyTable: noconvìcatenate

Load * resident Tab1;

left join

Load distinct *, 'Y' as flag resident Tab2;

Now, where you find 'Y' it means that a code from tab2 matches with an identical code in tab1 otherways you have unmatching codes

Hope it helps

Re: Quality test - comparing two fields

Wed, 10 Jun 2015 15:38:52 GMT

Thank you and thanks Alexandros17‌ your method works too.