Multiplying rows

[Juplo]

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!

[MarqueeCrew · Accepted solution]

@Juplo,

Here's a solution for you:  Transpose, Append, Formula, Cross Tab, voila c'est magnifique!

Cheers,

Mark

[Juplo]

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!

[MarqueeCrew]

I would lean towards the record ID solution. That would be my preference.

Cheers,

Mark