Tabular Structure

Full example of data filtering using a JSONPath filtering expression.

Input Data

| id        | Record 1              | Record 2             |
| --------- | --------------------- | -------------------- |
| variable1 |  record 1 variable 1  |  record 2 variable 1 |
| variable2 |  record 1 variable 2  |  record 2 variable 2 |
| sku       |  record1              |  record2             |

Data Filter

$[?(@.sku == record2)]

Filtered Data

| id        | Record 2             |
| --------- | -------------------- |
| variable1 |  record 2 variable 1 |
| variable2 |  record 2 variable 2 |
| sku       |  record2             |

Last updated

Was this helpful?