preceeding load from two tables

[markgraham123]

Hi,

I'm trying to do a preceeding load from two resident tables in the script.

"Quantity"  in TableA,

"360 dayvel." in Table B.

I wanna do the calculations:

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8 as [0-8WOH]

Anyone can give me hints.

[ramoncova06]

do you mean apply a join and then get this calculation ?

something like

one:

load

fields

from your table

join

load

fields

from your table two;

load

*,

calculations

resident one;

drop table one;

[markgraham123]

Table17:

LOAD SKU#,

          Sum([Qty On Hand]) as [Total Quantity]

  GROUP BY SKU#;

LOAD SKU#, [Qty On Hand]

Resident SKORT;

Join(Table17)

LOAD *

  Resident Table16;

Table18:

LOAD *,

  If(([Total Quantity]/([360-day Velocity]/52))>=0 and ([Total Quantity]/([360-day Velocity]/52))<=8, [360 0-8 WOH])

Resident Table17;

DROP Table Table16;

Lemme knw whether this is fine?

[ramoncova06]

yes, that should work, assuming that join between table 16 and table 17 is correct

[MarcoWedel]

please post some sample data and your exprected result.

thanks

regards

Marco