Sum/Aggregation help!

Wed, 10 Oct 2012 15:40:18 GMT

Hi,

I have the following Load code that result in the table shown.

DRP:

LOAD @1:27 as part_key,

@230:239 as [week 1],

@254:263 as [week 2],

@278:287 as [week 3],

@302:311 as [week 4]

FROM [$(sLastFile)] (fix, codepage is 1252)

WHERE @52:55='B';

What I want to achieve is to aggregate the amount starting with week 1. Would like the following resulting table;

Is there any simple code for this. Given that it's 52 weeks I'd prefer not to use the following code;

DRP:

LOAD @1:27 as part_key,

@230:239 as [week 1],

@230:239+@254:263 as [week 2],

@230:239+@254:263+@278:287 as [week 3],

@230:239+@254:263+@278:287+@302:311 as [week 4]

FROM [$(sLastFile)] (fix, codepage is 1252)

WHERE @52:55='B';

Thankful for any help!

Best regards,

Jonas

Re: Sum/Aggregation help!

Wed, 10 Oct 2012 15:53:10 GMT

The table shows production demand Part Numbers per week. What I want to accomplish is to sum the Production Demand within the Lead Time of the part.

I.e. if the Lead Time for part number PEFR9254 is 3 weeks I want to

sum([week 1]+[week 2]+[week 3]) = SUM(12+12+12) = 36

The lead time is different for different part numbers.

Jonas