Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Insert new rows for missing dates

R_SCOT
5 - Atom

Hi

 

Sort of a beginner to Alteryx, so, don't know if there is an easy solution. 

My original input file has 1000s of rows, 20 columns with data and last column is a date field.

If there is a missing date, I want to create new rows and copy the values from the previous date and add the new date. 

As per the attached sample file (2 tabs), input file is missing data for 24/10/2020 & 25/10/2020.

Required output should

1. Insert data from 23/10/2020 and add date as 24/10/2020.

2. Insert data from 24/10/2020 and add date as 25/10/2020.

 

Hoping someone can help.

Thanks!

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @R_SCOT 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1603864797956.png

Workflow:

atcodedog05_1-1603864809524.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

R_SCOT
5 - Atom

Thanks atcodedog05,

I was able to apply your workflow to mine and it worked. Got the output that I was after. 

Thanks for the prompt response!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @R_SCOT 

 

Cheers and Happy Analyzing 😀

Labels