topic Re: Multiplying rows in Alteryx Designer Desktop Discussions

Multiplying rows

Juplo — Thu, 24 May 2018 04:45:24 GMT

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:

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!

Re: Multiplying rows

MarqueeCrew — Sat, 20 Jan 2018 17:52:13 GMT

@Juplo,

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

Cheers,

Mark

Re: Multiplying rows

Juplo — Mon, 22 Jan 2018 11:11:55 GMT

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!

Re: Multiplying rows

MarqueeCrew — Mon, 22 Jan 2018 11:29:03 GMT

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

Cheers,

Mark