Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
abhinavbose
Contributor III

How to join tables for matching fields

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.

Tags (2)
1 Solution

Accepted Solutions
passionate
Valued Contributor

Re: How to join tables for matching fields

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

View solution in original post

3 Replies
passionate
Valued Contributor

Re: How to join tables for matching fields

Hi Siva,

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

You can use applymap.

PFA Solution

Regards,

Pankaj

abhinavbose
Contributor III

Re: How to join tables for matching fields

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

passionate
Valued Contributor

Re: How to join tables for matching fields

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

View solution in original post