How to load data with a filter on related table

[#1]

Hello! I have the following problem. I want to load data from three excel tables:

BUT I don't want to load sales in Brazil. So, my result must be:

If I could use SQL, I would wright the following code:

SELECT * FROM Sales LEFT OUTER JOIN Managers ON Sales.[Manager ID]=Managers.[Manager ID] LEFT OUTER JOIN Regions ON Managers.[Region ID]=Regions.[Region ID] WHERE NOT Regiopns.Name LIKE 'Brazil';

What loading commands should I wright in QlikView loading script??? I have been looking for solution about 5 hours and I couldnt solve this problem. Help, please!

[alexandros17]

Load * FROM Sales;

LEFT JOIN

Load * From Managers;

Inner JOIN

Load * From Regions Where [Region ID] <> 2;

let me know

[Anonymous]

Something like this should work:

Sales:

LOAD

Amount,

Manager_ID

From Sales;

Left join(Sales)

Load

Name as ManagerName,

Manager_ID,

Region_ID

From Managers

where not Region_ID=2;

Left join(Sales)

LOAD

Names as RegionName,

Region_ID

From Regions;

[#4]

I lose manager with ID=3 if I use this script

[alexandros17 · Accepted solution]

So use this script,

TEMP:

Load * FROM Sales;

LEFT JOIN

Load * From Managers;

LEFTJOIN

Load * From Regions ;

MyTable:

noconcatenate

Load * resident TEMP Where [Region ID] <> 2;

drop table TEMP;

let me know

[#6]

Unfortunately, for this script I have the following strange result:

[#7]

IT WORKS! Thank you very much, Alessandro!