Time for action—checking films file with the Data Validator
Let's validate not only the
Genres field, but also the
- Open the last transformation and save it under a new name.
- Delete all steps except the Text file input and Text file output steps.
- In the Fields tab of the Text file input step, change the Type of the
- From the Validation category add a Data Validator step. Also add a Select values step. Link all steps as follows:
- Double-click the Data Validator step.
- Check the Report all errors, not only the first option found on at the top of the window. This will enable the Output one row, concatenate errors with ...