nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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".