Script: Load data and reduce based on input from an Excel file.

[#1]

Dear Ladies and Gentlemen,

I would appreciate your help on the topic following.

Order	Location	CostCenter
1	USA	A0001
3	China	B0003
7	China	C4032
8	USA	K3003
8	Sweden	L3003

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.

[flipside]

Hi,

There's a few ways to do this but I find an INNER JOIN the easiest ...

Costcenters:

Load * inline [

CostCenter

A0001

C4032];

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.

flipside