Generate Rows for missing dates in the month

Hi All - I am looking at generating rows for dates that are missing from the month.

for e.g. the input file has dates from 1may to 23 may currently, is there a way for Alteryx to generate rows for 24may-31may and populating the data from 23may?

if i were to update that input file such that it has data from 1may to 25may, Alteryx will then generate rows for 26may-31 may and populate the date from 25may?

Workflow

Date Time

Preparation

Accepted answers

All comments

JosephSerpis

Hi @yeojy the Generate row tool is perfect for this scenerio you can even feed in fields so the date caculations are dynamic just as you set out in your scenerio.

binu_acs

@yeojyas @JosephSerpis mentioned you need to use the Generate Row tool

Generate_Row_25_05.yxmd

yeojy

hihi @binuacs thank you so much! i tried using your method but i do have other data and there are NULL in some of the rows, which is causing the loop expression to not work. and is there a way to not use the summarize tool?

binu_acs

@yeojy Can you provide some sample records and expected output file?

yeojy

hihi attached sample.xlsx is the raw report that i work with, while the sample(desired output).xlsx is the desired output that i wish to have. so assuming the raw report that i have has data till 26may, i should generate new rows up till 31may with the data of 26may.

Sample(Desired Output).xlsx

Sample.xlsx

Christina_H

This will do it:

Generate missing dates.yxmd

binu_acs

@yeojy Another way of doing this without the summarise tool

Generate_Row_25_05.yxmd

yeojy

@Christina_H @binuacs thank you so much! both works, but I have only one more problem which is that I have 2 different ID for the same Name, so using what both have provided, it only creates the data for one of the ID and not both, any suggestions to how i can achieve that? have attached the sample and desired output again, Thanks in advance!

Sample.xlsx

Sample(Desired Output).xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703