topic Re: How to join tables for matching fields in QlikView

How to join tables for matching fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two tables A and B. Table A can have more rows compared to table B.

Now I need to compare for exactly matching fields of table B from table A. But I also want to maintain total count, matched count and unmatched count in the data model.

In this case, how to join these two tables and get these data without duplicates. Also attached some sample data with this.

Please help.

Thanks,

Siva.

Re: How to join tables for matching fields

passionate — Thu, 10 Aug 2017 15:31:59 GMT

Hi Siva,

You don't need to join for getting your results.

You can use applymap.

PFA Solution

Regards,

Pankaj

Re: How to join tables for matching fields

Anonymous — Thu, 10 Aug 2017 15:37:01 GMT

Thanks Pankaj. But I need to compare the combination of three columns using autonumber function. In that case, applymap is possible?

Re: How to join tables for matching fields

passionate — Thu, 10 Aug 2017 16:21:45 GMT

Hi Siva,

Follow below steps:

Concatenate the three fields to form a single field eg: Feild1&field2&field3&field4

Then use this field in Applymap with same logic.

This would work.

Regards,

Pankaj