Hi all,
I tried so search but couldn't find the answer. My data are as follow:
Table 1
ID | col1 | col2 | col3 | col4 | col5 |
1 | 15 | 152 | 45 | 256 | 65 |
2 | 547 | 8 | 2545 | 51 | 1564 |
3 | 555 | 545 | 4 | 24545 | 254 |
table 2
Coef | Coef1 | Coef2 | Coef3 | Coef4 | Coef5 |
I want to multiply every row of the table 1 by the coefficient in table 2, for example for ID 1:
1 | 15*Coef1 | 152*Coef2 | 45*Coef3 | 256*Coef4 | 65*Coef5 |
And so on for all rows in table 3 (I have about 10k rows)
How can i do this?
Thanks!
Solved! Go to Solution.
Thanks @MarqueeCrew,
That works perfectly! I was able to open the workflow (my alteryx version is older) but the picture itself was more than enough!
Quick side question: my record ID is in fact made of multiples columns (40-50). Is it faster if i use a recordId early and put the multiple columns aside, then join again right at the end? Or that wouldn't affect significantly the workflow speed and I don't need to?
Thanks again!