File Missing Dates

[ptomljanovic12]

I have a file that is missing 1/1/2020 and 12/31/2020 and the respective data that goes with those dates, how can I add these to the file?

[christine_assaad · Accepted solution]

Hi @ptomljanovic12 

If you have this data, you can copy it and past it to the canvas or have it added in a "Text Input", then you can add "Union" to add these rows to the original file based on headers.

If you would like to generate dates, then you can use "Generate rows". 

If you can provide some data samples, this could help as well. Thanks!

[Emil_Kos]

Hi @ptomljanovic12,

As @christine_assaad said the easiest way to achieve it is using union tool.

I have included also a sort on a date in case you would need it. 

I would encourage you to check some kind of introductory videos under the link below:

https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161