Validating PAT_MRN_ID Across Three CSV Files

digital-preservation / csv-schema

CSV Schema

http://digital-preservation.github.io/csv-schema

Mozilla Public License 2.0

100 stars 33 forks source link

Validating PAT_MRN_ID Across Three CSV Files #48

Closed megin1989 closed 3 months ago

megin1989 commented 3 months ago

I have three CSV files: Screening, QeAdmin, and Demographics.

I need to validate that every PAT_MRN_ID in the Screening CSV matches the PAT_MRN_ID in both the QeAdmin and Demographics CSVs for the corresponding FACILITY_ID.

Additionally, how can I perform this validation across all three files?

adamretter commented 3 months ago

I think the CSV Schema at present is designed to operate on a single CSV file.

DavidUnderdown commented 3 months ago

Correct, see digital-preservation/csv-validator/issues/501

This is out of scope for csv-schema language