Discussion board where members can get started with QlikView.
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.
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.
View solution in original post
You don't need to join for getting your results.
You can use applymap.
Thanks Pankaj. But I need to compare the combination of three columns using autonumber function. In that case, applymap is possible?