Example 3 – Large Amount of Errors

Setup

The same dataset as in Example 2 – Transaction Data without Header and Dates (but duplicated).
Large amount of validation errors.

Dataset

IL000000001,2015/11/29,CD-00038,MB-0005,27,12.7,1.7145,5.275491,EUR,kg,12.3.2021
IL000000002,2015/11/29,CD-00138,MB-0018,202,11.7,2.541020625,4.971780667,EUR,kg,12.3.2021
IL000000003,2015/11/29,CD-00097,BV-0007,27,0.99688,0.063700632,0.55,EUR,kg,12.3.2021
IL000000004,2015/11/29,CD-00038,MB-0019,202,11.7,1.5795,5.0727456,EUR,kg,12.3.2021
IL000000005,2015/11/29,CD-00094,MB-0028,2,3.125,0.680976563,2.5,EUR,kg,12.3.2021
IL000000006,2015/11/29,CD-00007,MB-0035,30,2.75,0.2288,2.2,EUR,kg,12.3.2021
IL000000007,2015/11/29,CD-00008,MB-0013,198,6.32,1.055835,4.2718416,EUR,kg,12.3.2021
IL000000008,2015/11/29,CD-00055,MB-0010,16,12.7,0.42433875,5.308082,EUR,kg,12.3.2021
IL000000009,2015/11/29,CD-00097,MB-0042,23,2.673,0.169000425,1.65,EUR,kg,12.3.2021
IL000000010,2015/11/29,CD-00144,MB-0049,5,3.19725,0.694382752,2.45,EUR,kg,12.3.2021
IL000000011,2015/11/29,CD-00092,MB-0053,1,5.48275,0.723517397,4.55,EUR,kg,12.3.2021
IL000000012,2015/11/29,CD-00016,MB-0059,51,6.4125,0.35204625,4.5,EUR,kg,12.3.2021
IL000000013,2015/11/29,CD-00008,MB-0016,221,13.02,2.17515375,5.180084,EUR,kg,12.3.2021
IL000000014,2015/11/29,CD-00111,MB-0060,3,22.3795,1.38976695,15.65,EUR,kg,12.3.2021
IL000000015,2015/11/29,CD-00051,MB-0013,42,6.32,0.36498,4.2718416,EUR,kg,12.3.2021
...

Schema

{
  "title": "Pricefx data schema for set 3 - Invalid transactions",
  "name": "My Pricefx Schema 3",
  "description": "Lorem ipsum",
  "options": {
    "headers": [
      "Transaction Id",
      "Invoice Date",
      "Customer Id",
      "Product Id",
      "Quantity",
      "List Price",
      "Discount",
      "Cost",
      "Currency",
      "UOM",
      "PricingDate"
    ]
  },
  "fields": [
    {
      "name": "Transaction Id",
      "constraints": {
        "type": "STRING",
        "minLength": 11,
        "maxLength": 11
      }
    },
    {
      "name": "Invoice Date",
      "constraints": {
        "type": "DATE",
        "datePattern": "dd.MM.yyyy"
      }
    },
    {
      "name": "Quantity",
      "constraints": {
        "type": "INTEGER",
        "maximum": 10
      }
    },
    {
      "name": "PricingDate",
      "constraints": {
        "required": true,
        "type": "DATE",
        "datePattern": "dd.MM.yyyy"
      }
    }
  ]
}

Errors

        result.rows == 1115
        !result.valid

        result.errors.size() == 2705
        result.errors[0].detail == 'Value 2015/11/29 is not date in pattern dd.MM.yyyy'
        result.errors[0].row == 1
        result.errors[0].col == 1

        result.errors[1].detail == 'Value 27 is more than maximum 10'
        result.errors[1].row == 1
        result.errors[1].col == 2