If any record with same ID equals x then x else?

[BigDataGeek]

I'm trying to figure this out and can't think it through.

I have multiple rows with the same file ID.   What I need to do is say if any row with the same ID equals open, then open else closed.

[christine_assaad]

Hi @BigDataGeek 

Please check if the below is what you are looking for.