I am new to qlikview. I have a requirement to compare the data between two difference sources and find the existence of a the field. (source A holds all req types together but source B has different tables for each rep type)
Example:
Table A Table B_OR Table B_CR Table B_RT
ID req_type trade_date ID req_type trade_date ID req_type trade_date ID req_type trade_date
1 OR 8/3/2016 1 OR 8/3/2016 1 CR 8/3/2016 1 RT 8/3/2016
2 OR 8/3/20163 OR 8/3/2016 3 RT 8/3/2016
1 CR 8/3/2016 5 OR 8/3/2016
1 RT 8/3/2016 4 OR 8/3/2016
3 OR 8/3/2016 6 OR 8/3/2016
3 RT 8/3/2016
4 OR 8/3/2016
4 CL 8/3/2016
8 OR 8/3/2016
My output should display the count of ID based on the rep_type for two tables and difference between them. Also, It should display the Id stating the issue as below: