In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiplying the amount of rows by a certain number

BillyL14
8 - Asteroid

Hi all

I have a table like this.

2a

2b

2c

2d

 

I would like the frequency of the value in this table to increase based on the week I put.

For example if the above was week 1, this would be week 2

2a

2a

2b

2b

2c

2c

2d

2d

 

I have tried messing around with the multi row formula but not really not getting anywhere

 

Thanks a lot

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

So something like this?

PhilipMannering_0-1640194702372.png

 

BillyL14
8 - Asteroid

yes that looks great, haven't used that tool before, thanks!

Labels
Top Solution Authors