Discussion board where members can get started with QlikView.
After running a sql query thru a team and left left joining on a 'ReportsTo' field, I am left with 3 tables. e.g.:
1 How can I eliminate id2 and id4 from the Team table.
2 How can I eliminate Id4 from the Supervisor table?
Thanks for any help
Go to Solution.
You can get what you want using not exists(). For example:
team_id in Team Table
supervisor_id in Supervisor Table
manager_id in Manager Table
Then you need to :
Load * resident Team_table where not exists(supervisor_id,team_id);
Load * resident Supervisor_table where not exists(manager_id,supervisor_id);
These 2 tables above is what you want.
Thanks this produced the subsets I needed. I followed with joins to merge into single table with columns for supervisors and managers.