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
Solved! Go to 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
Thanks @IraWatt !!
No worries @Danilo9017 :) glad it all worked for you !