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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels