# Conditional if nod

**URL:** <https://community.parabola.io/t/conditional-if-nod/2132>\
**Category:** Ask a question\
**Created:** [November 15, 2021, 1:15pm UTC](https://community.parabola.io/t/conditional-if-nod/2132 "2021-11-15T13:15:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cindy\_Grozdanic](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@Cindy\_Grozdanic](https://community.parabola.io/u/Cindy_Grozdanic)\
**Post date:** [November 15, 2021, 1:15pm UTC](https://community.parabola.io/t/conditional-if-nod/2132/1 "2021-11-15T13:15:24Z")

</div>

Hello,  
We are doing a pipeline separating “valid rows” and “invalid rows”.  
“valid rows” will be implemented in an application and “invalid rows” will be sent in a google sheet and sent by email.  
We would like to do this action with a condition : if there is no “invalid rows”, the “valid rows” could be sent in the final application and if there is minimum 1 “invalid row”, the “valid rows” wouldn’t be sent in the final application.  
Maybe someone knows if it possible to add a sort of “conditional if nod”?  
Thank you very much in advance for your help.

---

<div class="post-metadata">

**Author:** ![brian](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian/32/11_2.png) [@brian](https://community.parabola.io/u/brian)\
**Post date:** [November 15, 2021, 5:48pm UTC](https://community.parabola.io/t/conditional-if-nod/2132/2 "2021-11-15T17:48:25Z")

</div>

Hey there! Sounds like you want to make sure that no rows are allowed through this section if any of the rows are “invalid”. Here is a way to do that!

 ![Screen Shot 2021-11-15 at 9.42.35 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/2/26d9c4490ae6e258fef88ce6d067c54d7c760529.jpeg)

Use the Insert If/Else column step to perform the valid / invalid checking. In this case I am checking if the email column contains “netflix”. The important part here is that you use this step to tag any invalid rows with a word (such as “BLOCK” in this case), and keep the valid rows blank in that new column:

 ![Screen Shot 2021-11-15 at 9.42.52 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/1dfe9a9937ffca46df7a82c502f7f102ae6564d1.jpeg)

Then use the Fill in Blanks step to fill in the new “Valid Check” column from both the top and the bottom. This will ensure that if any BLOCKs show up, they will be shared with all other rows.

 ![Screen Shot 2021-11-15 at 9.43.02 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/3bb8578b70e1eaa9bbc71df8d0084d0ac885f862.png)

Finally, use a row filter to only keep rows that are blank in that “Valid Check” column. This will let all rows through if all rows are valid, and will block all rows if at least 1 row is invalid.

 ![Screen Shot 2021-11-15 at 9.43.10 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/e/e47db6b0a725072f895d0ed0cb7949dda9439cfc.jpeg)

Paste this into your flow to check it out!  
`parabola:cb:79af2858c8cb476e9f6643115a75b5de `

---

<div class="post-metadata">

**Author:** ![Cindy\_Grozdanic](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@Cindy\_Grozdanic](https://community.parabola.io/u/Cindy_Grozdanic)\
**Post date:** [November 15, 2021, 7:26pm UTC](https://community.parabola.io/t/conditional-if-nod/2132/3 "2021-11-15T19:26:50Z")

</div>

Thank you very much for your help.

There is just a nuance. When I split “valid rows” and “invalid rows”, I want to send “valid rows” in an application but only if there is no “invalid row” detected. If there is one or more invalid rows, I will first correct it after sending all the rows which will be valid in the application.

Do you understand what I mean?

Thank you in advance 🙂

---

<div class="post-metadata">

**Author:** ![brian](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian/32/11_2.png) [@brian](https://community.parabola.io/u/brian)\
**Post date:** [November 16, 2021, 12:46am UTC](https://community.parabola.io/t/conditional-if-nod/2132/4 "2021-11-16T00:46:34Z")

</div>

> [@Cindy\_Grozdanic](#):
>
> I want to send “valid rows” in an application but only if there is no “invalid row” detected.

This will be accomplished by what I sent above. The steps will block any row from proceeding bast the Filter Rows steps if there are one or more invalid rows.

> [@Cindy\_Grozdanic](#):
>
> If there is one or more invalid rows, I will first correct it after sending all the rows which will be valid in the application.

Does this mean you want to send the valid rows somewhere else? I’m not sure I follow this part.

Is there a piece of what I sent above that is not working for you as expected?

---

<div class="post-metadata">

**Author:** ![Cindy\_Grozdanic](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@Cindy\_Grozdanic](https://community.parabola.io/u/Cindy_Grozdanic)\
**Post date:** [November 17, 2021, 3:27pm UTC](https://community.parabola.io/t/conditional-if-nod/2132/5 "2021-11-17T15:27:03Z")

</div>

It is working, thank you very much for your help.
