For a recent report build in Qlik sense I have joined two tables. Table A and B. Both tables include Emails but A includes most emails and B includes less. Because of this not all A emails exist on B.
When joining in SQL there is absolutly no issue at all. I have built out two procedures to pull the data and those procedures are included into the qlik data load editor. I use the data manager page to link the two on emails which should have some 1>1 connections as the same emails exist on both procedures. The problem is when I link them in the data manager and go to the sheet B. I show emails from both procedures in the same table and it looks like its duplicating every email one to many. No idea why this is happening but it is now causing filtering by email to not work. You click on a single email on one sheet that should exist on both but it wont filter the other sheet to the same email. My question is if both tables include a distinct email field that match one to one why is it then matching one to many and duplicating all of my data when breaking out by emails?
Thanks,
Analyst
