Group Users by Same Terminal, Window of Time

[CMH]

Hi Alteryx Community, 

I'm trying to sort out a way to identify and group users who logged in to the same computer terminal on the same day within a given window of time. 

For example: Which User IDs logged in to the same terminal on the same day within one hour of each other? I've attached some sample data as a reference. Ideally I would like to be able to tweak the date/times ranges for different applications. 

Thanks very much!

Log_On_Date	Log_On_Time	Terminal	User_ID
3/13/2017	11:42:43	1235	155555554
4/17/2017	22:40:11	1236	166666665
4/19/2017	10:13:15	1237	177777776
4/20/2017	9:50:03	1238	188888887
6/3/2017	15:31:02	1239	199999998
6/4/2017	3:17:03	1240	222222220
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109
2/21/2018	9:20:27	9000	499999995
3/22/2018	12:32:17	9001	511111106
4/23/2018	4:48:06	9002	522222217
5/14/2018	4:54:16	9003	533333328
5/15/2018	9:51:05	9004	544444439

[ponraj]

It would be great you could share the sample result you are looking for...

[CMH]

Hi Ponraj, 

Thank you for your help. In the sample data (Example A) there two users active on the same terminal within an hour on the same date (6/4/2017). As a result, I'm hoping the final output would be something like this (see Example B below). 

Example A: Sample Data 

Log_On_Date	Log_On_Time	Terminal	User_ID
3/13/2017	11:42:43	1235	155555554
4/17/2017	22:40:11	1236	166666665
4/19/2017	10:13:15	1237	177777776
4/20/2017	9:50:03	1238	188888887
6/3/2017	15:31:02	1239	199999998
6/4/2017	3:17:03	1240	222222220
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109
2/21/2018	9:20:27	9000	499999995
3/22/2018	12:32:17	9001	511111106
4/23/2018	4:48:06	9002	522222217
5/14/2018	4:54:16	9003	533333328
5/15/2018	9:51:05	9004	544444439

Example B: Output 

Log_On_Date	Log_On_Time	Terminal	User_ID
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109

[ponraj · Accepted solution]

Here is the sample workflow for you case. Hope this is helpful. 

WorkflowResults

[CMH]

Hi Ponraj, 

Thanks so much for your help on this. For some reason I am unable to download your workflow. I'm not having problems downloading other workflows from Alteryx community, but I keep getting a "network error" with your attached file. Would you mind re-sending? Thanks again! 

[CMH]

Update: I switched browsers and it worked! Thanks so much for all your help on this