Alteryx Designer Desktop Discussions

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

generating rows/records

SouravKayal
8 - Asteroid

Hi ,

 

So i have a data set of about 7M records. I have data in column format

 

A few columns of Months are empty. If i want to fill them using the generate rows tool using a previous month trend. How could i do that ?

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @SouravKayal,


As you didn't provide an example of data that would be hard to help. 


I have created a workflow today that creates month columns based on the date range. Please check the workflow for reference. 

SouravKayal
8 - Asteroid

I want to populate the rest of the month

T_Willins
14 - Magnetar
14 - Magnetar

Hi @SouravKayal,

 

What data do you want in the new columns?  Null/blank, Average of all previous months, duplicate of last month, or ?

 

Generate New rows question.png

Labels