Mapping ??

[#1]

Probably a mapping solution but I'm not sure how to do it.

I have two tables, both with stock code numbers. The first table has a descritpion field for Base Unit of Measure such as "BAG", "PAK", "FT" . .  and for each stock code there is only one Base Unit of Measure.  The second table will list the stock code mulitple time for the  Unit of Measure because it holds a conversion factor. So an item in the second table for part "A" may have:

Unit of Measure   - Conversion Factor

FT                     -  1000

EA                    -  1

M                      -  1525

I need to produce one table that shows the following:

Stock Code           - Unit of Measure(table 1)    - Conversion factor (table two)

A  (from table 1)     -   FT (from table 1)             -    1000  (from table 2 but I only want the conversion factor where the Unit of Measure is FT)

Thanks,
Stephen

[fernandotoledo]

Now I got it!

Stock Code	Unit of Measure	From Unit	From Factor	To Unit	To Factor
A	FT	FT	1000	EA	1
B	BAG	BAG	1	EA	25
C	PAK	PAK	1	EA	50

See the atached file again!

You have to create a sequence of joins to create a From Unit - To Unit logic.

[#3]

Fernando,

First, thanks for your help. We are almost there. In the last column (To Factor) I need the FT item to show 1000. In other words, I need the EA quantity for the items "BAG" and "PAK" (as you have it) but I need the "FT" quantity for the FT item.

Thanks,
Stephen

[fernandotoledo]

That´s it! I put a final load statement to filter only de desirable conversions in your table!

[#5]

Exactly what I need!! Thank you Frenando you have been a huge help to me.

Stepen

[fernandotoledo · Accepted solution]

Glad I could help!

Dont forget to mark the correct answer for the other users who might find this topic helpfull.

Best regards!

Fernando