Merge two columns to show distinct count of id as well as all null items.

[knobsdog]

I have a workflow that is counting unique Id numbers as well as any null values to get an item total.  I used a unique tool to count distinct ids and a separate path counting nulls but I can't seem to figure out how to merge them back into one column.

Separate Columns show count of items with an id and those without an id.
Release Date	Design Stage	Id	Null_Id
12/13/2020	Validation	1
12/16/2020	Validation	8
12/21/2020	Validation	2
12/11/2020	Validation		1
12/16/2020	Validation		1
Need to merge columns to get a total count of items with id and null total.
Release Date	Design Stage	Id	Null_Id
12/13/2020	Validation	1
12/16/2020	Validation	9
12/21/2020	Validation	2
12/11/2020	Validation		1

[BrandonB · Accepted solution]

Maybe a summarize where you group by Release Date and Design Stage and then sum the count of IDs and Null IDS, then use a formula tool to sum the two columns together? 

 

[pedrodrfaria]

Hi @knobsdog 

Could you please provide a sample of the dataset you are working with, this way we will be able to better assist you.

You can use the Summarize tool to count distinct a ID field and count null values as well.