Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Load * FROM Sales;
LEFT JOIN
Load * From Managers;
Inner JOIN
Load * From Regions Where [Region ID] <> 2;
let me know
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;
I lose manager with ID=3 if I use this script
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
Unfortunately, for this script I have the following strange result:
IT WORKS! Thank you very much, Alessandro!