Multyply two tables , same structure field

Danilo9017

Hi Team 

I struggling with moltiplication of two tables ( i inserted on alteryx two inputs) 

input data 1 

Input data  2 

Basically the structure of the fields it is the same. I just need as output the result of  multiplication of each matching cell: 

so for example  the first cell o  output;  "agen be" sum of >270 will be: 57'590*0,567=32653,7 (find all highlighted in yellow)  ... and so on

Is there a workflow to obtain this desired output below  on alteryx? I know i could use the join tool , but i get lost when i should tell to the system to create a multiplication   between the same fields columns and row....

This the output i would need.

Please find attached the related files 

Danilo 

OUTPUT.xlsx

INPUT 1.xlsx

INPUT 2.1.xlsx

IraWatt

Hey @Danilo9017,

This workflow transposes then joins the two data sets on the column name and label then applies your formula:

If theres any adjustments or questions you have please ask

HTH,

Ira

Transpose 2405.yxmd