Replies: 3 comments 2 replies
-
You can use it to ensure that all fields in the csv file are of the correct type, within specified ranges, or match certain patterns. Although you can try creating a JSON Schema file from jurisdictions.csv file using the See https://github.com/jqnatividad/qsv/blob/master/src/cmd/validate.rs#L2 |
Beta Was this translation helpful? Give feedback.
-
The Just start with a "training" CSV to run the qsv/scripts/NYC_311_SR_2010-2020-sample-1M.csv.schema.json Lines 30 to 67 in 1efa6b5 If the I have an extended example at https://github.com/dathere/qsv-lookup-tables. |
Beta Was this translation helpful? Give feedback.
-
Now that the Though I'm sure we can have a full-blown WDYT? |
Beta Was this translation helpful? Give feedback.
-
If I have one CSV that includes a
jurisdiction
column, is there currently a way tovalidate
that all the values in that column have a matching entry in ajurisdictions.csv
file?I can do that as a one-off check with
qsv join --left-anti
, but I'm not familiar enough with JSON Schema to be able to work out ifqsv validate
can handle this sort of integrity checking.Beta Was this translation helpful? Give feedback.
All reactions