How to Fetch all records while validating snap :

how to fetch all records in filereader snap while validating pipeline ?
means i have 600 rows in a excel which i need to get in output view of filereader snap which is followed by a Excel parser ??

Why do you need all the records in validation?

Pretty sure the limit 50 on the validate cannot be changed. You could add an email snap to email the output to you, or write to a database or file.

1 Like

@nsmith is correct. Validation only works with 50 records so you get an idea of what your pipeline is doing. Execution will use all applicable data.

1 Like


If you want to check specific data set after first 50 records two ways-

  1. Write your response on file writer then check.
  2. Customize your query based your specific data set.
1 Like