Adding rows with a blank column

[muns]

Hi everyone,

I am trying to figure out how to add rows to my table based on my first column (Year) but leaving my second column (X) blank?  I'm pretty sure it must be the Generate Rows tool but haven't been able to configure it correctly.

This is what I'm trying to achieve:

Before		After
Year	X		Year	X
2010	10		2010	10
2011	20		2011	20
2012	30		2012	30
2013	40		2013	40
2014	50		2014	50
			2015	blank
			2016	blank
			2017	blank
			2018	blank

Many thanks,

Mark

[Jonathan-Sherman]

Hi @muns,

You could simply join on a reference table with all years you want to appear in the data set and union:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[RolandSchubert · Accepted solution]

Hi @muns ,

you could identify the last entry in your existing table by a Summarize tool (using "MAX"),
create additional years (starting with last existing year until current year using the Generate Rows
tool, and use Union to get the completed table. I've attached a workflow.

Best regards

Roland

[muns]

Thanks Robert and Jonathan for your solutions.

I went with Roberts suggestion in the end as it seems more dynamic if my base data changes.

Much appreciated.

Mark

[ashissanpui]

Add union app between two data sources. Your issue will get resolved.

[muns]

Apologies *Roland not Robert