ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Repeat Values in all rows

JonaV
7 - Meteor

Hi everyone, 

 

Can someone help me figure out a way to repeat all the values in the "Sum_TotalEmpl" column for Dec into all the rows? 

 

So what I want is to for example I want the 3,812 number to show in row 11 the same even though it is Apr

 

JonaV_0-1614126960105.png

 

Thanks!

 

Qiu
17 - Castor

@JonaV 

Something like this?

Capture4.PNG

mot
10 - Fireball

Hi @JonaV,

 

This is one way to do it:

Screen Shot 2021-02-23 at 7.50.42 PM.png

 

I hope this helps. Best!

JonaV
7 - Meteor

I've attached the Excel output file from my workflow.

 

So, essentially what I want to do is to repeat the "Sum_Total_Empl" for every record so that I can make a calc that takes the Ext Hires (excl Sep) and divides it by the PREVIOUS YEAR End total. For example, in row 12 I want the calculation in cell H12 to be 48/3812 (or E12/D12)

pedrodrfaria
13 - Pulsar

Hi @JonaV 

 

Is this what you are looking for?

 

pedrodrfaria_0-1614188934382.png

 

 

Pedro

 

JonaV
7 - Meteor

Doesn't look like it.

 

I want the "Sum_Total Empl" numbers for the first 10 records to show in the next 10 records.+

 

So, I want the 2017 Year End numbers (Dec) to show in 2018, the 2018 show in 2019 and so forth - for every month I want the Prior Year DEC numbers to show. The DEC numbers are my baseline for the calculation for every single month for every single record

 

Hope that makes sense

mot
10 - Fireball

Hi @JonaV,

 

I have a better understanding of your goal now. Please check the attached workflow. Best!

Screen Shot 2021-02-24 at 1.09.36 PM.png

 

 

Labels