{"action":"created","issue":{"url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/171","repository_url":"https://api.github.com/repos/digital-preservation/csv-validator","labels_url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/171/labels{/name}","comments_url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/171/comments","events_url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/171/events","html_url":"https://github.com/digital-preservation/csv-validator/issues/171","id":386176892,"node_id":"MDU6SXNzdWUzODYxNzY4OTI=","number":171,"title":"Errors referencing another column","user":{"login":"filipegarcia","id":944138,"node_id":"MDQ6VXNlcjk0NDEzOA==","avatar_url":"https://avatars0.githubusercontent.com/u/944138?v=4","gravatar_id":"","url":"https://api.github.com/users/filipegarcia","html_url":"https://github.com/filipegarcia","followers_url":"https://api.github.com/users/filipegarcia/followers","following_url":"https://api.github.com/users/filipegarcia/following{/other_user}","gists_url":"https://api.github.com/users/filipegarcia/gists{/gist_id}","starred_url":"https://api.github.com/users/filipegarcia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/filipegarcia/subscriptions","organizations_url":"https://api.github.com/users/filipegarcia/orgs","repos_url":"https://api.github.com/users/filipegarcia/repos","events_url":"https://api.github.com/users/filipegarcia/events{/privacy}","received_events_url":"https://api.github.com/users/filipegarcia/received_events","type":"User","site_admin":false},"labels":[{"id":33750531,"node_id":"MDU6TGFiZWwzMzc1MDUzMQ==","url":"https://api.github.com/repos/digital-preservation/csv-validator/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-11-30T12:56:48Z","updated_at":"2018-11-30T19:36:29Z","closed_at":null,"author_association":"NONE","body":"I can't have the check if a value is in another column working\r\n\r\nExplained in \r\nhttp://digital-preservation.github.io/csv-schema/csv-schema-1.1.html#ex-14-example-14-a_column-in-some-string-the-value-of-a_column-must-be-a-substring-of-some-string-eg-some-or-string-or-me-st-etc-another_column-in-a_column-the-value-of-another_column-must-be-a-substring-of-the-contents-of-a_column\r\n```\r\nExample 14\r\n\r\na_column: in(\"some string\")   //the value of a_column must be a substring of \"some string\" eg \"some\" or \"string\" or \"me st\" etc\r\nanother_column: in($a_column) //the value of another_column must be a substring of the contents of a_column\r\n````\r\n\r\nI'm trying something like \r\n```\r\nemployee_id: notEmpty\r\nemployee_name: notEmpty\r\nemployee_manager_id: in($employee_id) or empty\r\n\r\n```\r\n\r\n\r\nis this feature implemented?"},"comment":{"url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/comments/443315407","html_url":"https://github.com/digital-preservation/csv-validator/issues/171#issuecomment-443315407","issue_url":"https://api.github.com/repos/digital-preservation/csv-validator/issues/171","id":443315407,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MzMxNTQwNw==","user":{"login":"filipegarcia","id":944138,"node_id":"MDQ6VXNlcjk0NDEzOA==","avatar_url":"https://avatars0.githubusercontent.com/u/944138?v=4","gravatar_id":"","url":"https://api.github.com/users/filipegarcia","html_url":"https://github.com/filipegarcia","followers_url":"https://api.github.com/users/filipegarcia/followers","following_url":"https://api.github.com/users/filipegarcia/following{/other_user}","gists_url":"https://api.github.com/users/filipegarcia/gists{/gist_id}","starred_url":"https://api.github.com/users/filipegarcia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/filipegarcia/subscriptions","organizations_url":"https://api.github.com/users/filipegarcia/orgs","repos_url":"https://api.github.com/users/filipegarcia/repos","events_url":"https://api.github.com/users/filipegarcia/events{/privacy}","received_events_url":"https://api.github.com/users/filipegarcia/received_events","type":"User","site_admin":false},"created_at":"2018-11-30T19:36:29Z","updated_at":"2018-11-30T19:36:29Z","author_association":"NONE","body":"I get the same thing, \r\n```\r\n$validate test.csv schema.csvs\r\nError:   any($employee_id) or empty fails for line: 2, column: employee_manager_id, value: \"1234\"\r\nError:   any($employee_id) or empty fails for line: 3, column: employee_manager_id, value: \"1234\"\r\nFAIL\r\n```\r\nmy real data is also clean, no spaces before or after.\r\n\r\nI'm running `CSV Validator - Command Line 1.1.5`\r\n\r\n"}}
{"actor":{"display_login":"filipegarcia"}}