Visokio website     Downloads     Video tutorials     KnowledgeBase  
Validate Data: proceed only if minimum number of rows exist? - Visokio Forums
Validate Data: proceed only if minimum number of rows exist?
  •     MartijnVisser January 9, 2013 3:44AM
    Hi - Is it possible to have Omniscope check if at least X rows exist before proceeding to the next block?

    Best, Martijn
  • 2 Comments
  •     chris January 9, 2013 4:19AM
    Hi Martijn - Thanks for the question. Yes, it is possible to do this. You need to use the "Validate data" operation. This can be used to perform one or more checks on the entire block data-set. If any of the the checks fail, you can stop the data from flowing downstream to the next block.

    Connect your DataManager data flow to a Validate data operations block then switch to the "Custom" tab. Click the custom checkbox and then enter the validation formula:

    RECORDCOUNT() >= [X]

    where X is the minimum number of rows that should exist in the data.
  •     MartijnVisser January 9, 2013 5:42AM
    Thank you Chris!
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership