Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community.
I know this is pretty much straight forward but I can't find anywhere with a good example..
I have 2 excels:
Table 1:
Load
Cost
From...
Table 2:
Load
Values
From....
I need to create a field that does the following:
Cost * values.
If the fields had been in the same Load I wouldn't be bothering you at all...
Thank you.
Regards.
Hi,
what is the link between these tables ? to make this multiplication you need to know which cost correspond to which value
Not sure how these two tables are associated, but I think applymap may help here if you have same ID associated with two tables, create map table using ID and Cost from first table and then get the cost in 2nd table by looking Id in 2nd table using applymap.
They are associated by a Material ID.
please post sample data or sample app
As already suggested above, applymap may be of use in this
Here goes:
Table1:
MaterialID | Cost |
---|---|
1 | 400 |
2 | 540 |
3 | 420 |
Table2:
MaterialID | Values |
---|---|
1 | 2 |
2 | 10 |
3 | 5 |
I need a new field that does Cost*Values.
Thank you.
Regards.
do like this
Map_Cost:
Mapping Load
MaterialID,
Cost
Resident Table1;
Table2:
Load
MaterialID,
Values,
ApplyMap('Map_Cost',MaterialID,0) * Values As CostValues
Resident Table2;
What if the field is [Cost 2]?
What if the field was renamed? [Cost] as [Cost v2]
Thank you!.
Regards.