COVID Contact Tracing Model - Not sure what function to use?

[udles5666]

Hi Community,

I am stuck with a query here. Attached for reference

From the attached data set for Contact tracing, I need to trace who was in a particular zone in a particular time frame. 

Say for example - Batman is tested +ve, how will I be able to see who was in the zones with Batman. Within a time frame (say + - 30 min). The data set is only for a day to reduce the complexity. Can I populate 2 new columns names as Zones Accessed and Close Contacts somehow to answer this question? 

Apologies if this is still unclear, but feel free to ask if more clarification is required. 

Thanks,  

@grazitti_sapna

[grazitti_sapna · Accepted solution]

@udles5666 , for that apply a filter at the end and use this 

[Potential Case Name]!= [Close Contact]

I have attached the updated workflow for reference.

Thanks.