Finding multiple doc cases that do NOT have a specific document

Closed
Tri0de Posts 2 Registration date Friday October 16, 2015 Status Member Last seen October 16, 2015 - Oct 16, 2015 at 12:37 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 02:12 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 16, 2015 at 02:19 PM
what you mean each file has documents?
0
Tri0de Posts 2 Registration date Friday October 16, 2015 Status Member Last seen October 16, 2015
Oct 16, 2015 at 03:29 PM
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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768 > Tri0de Posts 2 Registration date Friday October 16, 2015 Status Member Last seen October 16, 2015
Oct 20, 2015 at 02:12 PM
i am still confused over your use of term "file" and document,
0