Adding rows with a blank column

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

Preparation

Accepted answers

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

RowsWithBlankColumn.yxmd

All comments

Jonathan-Sherman

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

20191129 - ScaffoldingData.yxmd

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

RowsWithBlankColumn.yxmd

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703