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 

[IraWatt · Accepted solution]

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

[Danilo9017]

Thanks @IraWatt !!

[IraWatt]

No worries @Danilo9017 :) glad it all worked for you !