Discussion Board for collaboration on QlikView Scripting.
Dear Ladies and Gentlemen,
I would appreciate your help on the topic following.
I'm loading in multiple Excle Files. All of them have a Orders and Cost Centers - as show above. This is about 500k of lines.
Then I've got another Excel Files, where all Cost Centers are mentioned, which I finally need.
How can I reduce my data set to only those cost Centers I need using the script.
A WHERE-Clause in the LOAD part is not appropirate as I would need to mention about 1000 Cost Centers.
Thank you for your help.
There's a few ways to do this but I find an INNER JOIN the easiest ...
Load * inline [
INNER JOIN (Costcenters)
Load * Inline [
Order, Location, CostCenter
1, USA, A0001
3, China, B0003
7, China, C4032
8, USA, K3003
8, Sweden, L3003];
... this example will leave you with just data for Orders 1 & 7.