Load: Create new field based on 2 different files

[patriciousa]

Hi Community.

I know this is pretty much straight forward but I can't find anywhere with a good example..

I have 2 excels:

• Tabla1
• Table 2

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.

[YoussefBelloum]

Hi,

what is the link between these tables ? to make this multiplication you need to know which cost correspond to which value

[Digvijay_Singh]

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.

[patriciousa]

They are associated by a Material ID.

[sasiparupudi1]

please post sample data or sample app

As already suggested above, applymap may be of use in this

[patriciousa]

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.

[sasiparupudi1]

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;

[patriciousa]

What if the field is [Cost 2]?

What if the field was renamed? [Cost] as [Cost v2]

Thank you!.

Regards.