4 Replies Latest reply: Jun 22, 2015 5:51 PM by Marco Wedel

# preceeding load from two tables

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.

• ###### Re: preceeding load from two tables

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

something like

one:

fields

join

fields

*,

calculations

resident one;

drop table one;

• ###### Re: preceeding load from two tables

Table17:

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

GROUP BY SKU#;

Resident SKORT;

Join(Table17)

Resident Table16;

Table18:

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?

• ###### Re: preceeding load from two tables

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