How to get the formula to stop populating once it reaches the end of the data

[tbruner]

Hey there, 

I created a simple IF statement to populate a new field, however, it is extending far beyond the record where my data ends. How can I efficiently tell the software to stop the formula at the end of my data? In the attached screenshot, my data ends at row 106.

[markcurry · Accepted solution]

Hi @tbruner , an IF formula won't create any additional rows, so there must be extra\blank lines in your data.  Prior to your formula tool you could add a Filter tool, and Filter where [Source Asset No] is not null.   (Or [Entity] is not empty) .  Hope that helps.

[tbruner]

Thank you, that worked for me