Forum Discussion

sunil_murthy's avatar
sunil_murthy
New Contributor
8 years ago

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 ??

5 Replies

  • nsmith's avatar
    nsmith
    New Contributor III

    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.

  • dmiller's avatar
    dmiller
    Former Employee

    @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.

    • Supratim's avatar
      Supratim
      Contributor III

      @sunil.murthy

      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.
  • pramisetti's avatar
    pramisetti
    New Contributor II

    There is an option in Settings where you can select the Preview doc count, maximum limit is 2000

  • kpatnala's avatar
    kpatnala
    New Contributor

    In user settings (gear icon) you can change preview doc count field, it is from 50 to 2000 (max)