Excluding columns from tests

You can select columns from the test case output comparison to be excluded by adding the columns to the ignore array in the specification then property.

Ignoring function prevents columns that contain nondeterministic data from affecting test results. It also excludes those columns from test comparisons, so unexpected output in those columns, or changes in the output of those columns, will not be detected by your test case. Using the exclude function reduces your test coverage and should be avoided if possible. A common technique to avoid nondeterministic outputs is to ensure that all inputs data sources and flow parameters are stubbed by your test specification.

{
    "then": [
        {
            "path": "ODBC_orders.csv",
            "stage": "ODBC_order",
            "link": "order_out",
            "ignore": [
                "Creation_date",
                "Last_updated"
            ]
        }
    ]
}