Script Question: Use item in a load statement within a formula in another load statement

[#1]

I have researched my question and have been unable to find an answer.

Here is my issue: I have two loads statements.  The first load statement contains fields from a product (dimensional) table.  This load statement includes a fields titled ITEM and a field titled STATFACTOR.  The second load statement contains shipment quantity information by item (and other key fields).  This load also contains a field titled ITEM.  I would like to take the STATFACTOR field from load one and add it into load two so that I can use it in a calculation within that load.

My Question: Is it possible to take a field from one load statement and add it into another load statement, and then use that field within a formula within the second load statement?  If so, can examples be provided?

Any assistance is much appreciated.

Thank you,

Godfrey

[swuehl · Accepted solution]

You can probably use a mapping table to achieve what you want, like

Table1:

MAPPING LOAD

ITEM,

STATFACTOR

from ...;

Data:

LOAD

FIELD1,

FIELD2,

ITEM,

...,

VALUEFIELD * applymap('Table1',ITEM), 'OnTime', 'Late') as YOURCALCULATIONUSINGMAP

from ...;