compare records on multiple dates

BosKev

Hi All,

I have a table with snapshot dates, each date there are multiple employee records with unique employee ID.

I want to be able to compare each date and find out who left or who got added. what's the most efficient way of doing this without creating hundreds of join tool? Thanks.

Date	Employee ID
1/1/2020	a
1/1/2020	b
1/1/2020	c
1/1/2020	d
1/2/2020	a
1/2/2020	b
1/2/2020	c
1/2/2020	d
1/3/2020	a
1/3/2020	b
1/3/2020	c
1/3/2020	d
1/4/2020	a
1/4/2020	e
1/4/2020	f
1/4/2020	d
1/5/2020	a
1/5/2020	b
1/5/2020	e
1/5/2020	d
1/6/2020	a
1/6/2020	b
1/6/2020	g
1/6/2020	d
1/7/2020	a
1/7/2020	b
1/7/2020	c
1/7/2020	h

echuong1

I'm not sure if the values from your workflow make sense? They don't seem to line up with the data.

Take a look at this workflow. It may be what you're looking for. You may have to adjust the logic a bit.

New Workflow2.yxmd