Example 4 – Row Count Mode

Setup

Option rowCountMode is set.
Dataset contains a validation error on each row (column 2 pattern does not match).
Result is still valid – this is useful if you need faster results without the need to check validation errors (e.g. to get number of rows to determine correct batching).

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"
    ],
    "rowCountOnly": true
  },
  "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"
      }
    }
  ]
}

Result

        result.rows == 1115
        result.valid