Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
That´s it! I put a final load statement to filter only de desirable conversions in your table!
Exactly what I need!! Thank you Frenando you have been a huge help to me.
Stepen
Glad I could help!
Dont forget to mark the correct answer for the other users who might find this topic helpfull.
Best regards!
Fernando