Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors