Hi All,
I have two seperate data sources which have different information that I need to relate to each other.
Table1:
Part Description
Estimated Usage
Table2:
Part Number
Real Usage
Now the problem I have is that Table 1 has part description is an annoying format which contains the part number I want to relate.
Example :Table1::Part Description = "BIG THINGY PN 344400" where as Table2::PartNumber = 344400
We have a mapping table that we use throughout the project and was hoping to somehow use this (unfortunately by the previous owner who no longer works for us)
I've created a tab within our mapping spreadsheet to try and convert the 'Part Description' from Table 1 to create a new Field, Just substituing out the last couple of characters. Unfortunately for different parts, there is a different length of part numbers so I am manually altering this.
My Mapping Table looks like the below:
| Part Description | Part Number Converted (from Part Description) |
|---|
| BIG THINGY PN 222000 | 222000 |
| OTHER THINGY SN 39002HHB2 | 39002HHB2 |
| BLAEXAMPLE PN 3N3EE741000012P01 | 3N3EE74100012P01 |
The data from Table 1 is downloaded daily, where as Table 2 is extremely rarely updated.
So my actual question!!
Is it possible, for Table1::PartDescription to be uploaded as the new MappingTable::PartNumberConverted instead using the likes of ApplyMapping?
If this doesn't make sense please just let me know and I will try to explain the best I can.
