Search/extract IDs for at least one instance of "x", and those IDs w/out "x"

[Imzadi_1701]

I am a relatively new Alteryx user, and I am not quite sure how to search for what I need to do, so I am hoping someone can help me. 

I have a database with multiple rows for each record ID and I need to search all instances of the same record ID to make sure it has a specific value assigned to at least one instance of those records and provide me a list of which record ID's have said instance, and which one's do not. 

In the example case attached, which record IDs contain the record type "General", and which do not. I need to create a "pass" scenario for those IDs with at least one instance of "General", and a "fail" scenario for those record IDs with no instance of the type "General". 

Any help is much appreciated!

[nagakavyasri · Accepted solution]

Is this expected Output?

[Imzadi_1701]

It looks like that helped!  There seems to be an issue on my end with some of our File ID's that might be causing me another issue.  Thank you!