topic Re: Best method for comparing unmatched records in QlikView

Best method for comparing unmatched records

Rach_jais — Sat, 16 Nov 2024 19:56:45 GMT

Hi all,

What is the best method to find unmatched records in QV/QS please?

Would outer join work, or can I just leave it to associative engine, and use calculated dimensions in straight / normal table?

Your advice, experience and opinions are much appreciated.

Tia

Re: Best method for comparing unmatched records

dplr-rn — Mon, 07 Oct 2019 17:00:12 GMT

Please elaborate on what you are trying to do with an example if possible.

Qlik engine will identify unmatched records effectively. But final answer will depend your scenario

Re: Best method for comparing unmatched records

Rach_jais — Tue, 08 Oct 2019 03:19:57 GMT

I have two tables of customer data and need to check for mismatches in customer names, if any. And final aim is to have one table with correct data.

Thanks for the reply.

Re: Best method for comparing unmatched records

dplr-rn — Tue, 08 Oct 2019 10:21:50 GMT

Can you share some sample data

Re: Best method for comparing unmatched records

Rach_jais — Tue, 15 Oct 2019 09:43:51 GMT

The data is nothing special, they are just 2 tables of the same format recorded/captured differently, hence checking for dissimilarities. I have used join, as I did not want the associative engine to bring in non-common records and thus taxing on thx resources.

Thanks all for your replies.