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

Thu, 06 Dec 2012 14:37:56 GMT

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.

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

flipside — Thu, 06 Dec 2012 14:44:53 GMT

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