Finding multiple doc cases that do NOT have a specific document

Closed
Report
Posts
2
Registration date
Friday October 16, 2015
Status
Member
Last seen
October 16, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Thank you for letting me post here.

My question:

I have several thousand case files, a different one for each of several thousand clients. There are between 9 and 40 documents in each file.

I want to be able to find which cases DO NOT have any of four specific documents, as each file is required to have these specific documents, in addition to potentially 36 others that may or may not be in there.


Is this do-able?

Thank you.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what you mean each file has documents?
0
Posts
2
Registration date
Friday October 16, 2015
Status
Member
Last seen
October 16, 2015

Yes.
Case #a456785 might have 35 documents, case B789123 might have 12 document, and on and on for another 5-6000 cases.

There are four docs, call them 'Doc A', 'Doc B', 'Doc F' and 'Doc Z1' that are required to be in every file.

If I have a list of every doc in every file, one row for each doc, haw can I identify which files are missing which docs?

Thanks!
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 >
Posts
2
Registration date
Friday October 16, 2015
Status
Member
Last seen
October 16, 2015

i am still confused over your use of term "file" and document,
0