check numeric column if complete

Hi guys!

I'm looking for the best practise to check if a numeric column is complete or something is missing.

May someone help me?

Thanks.

Accepted answers

Thanks Jonathan,

Your second option is perfect!. The ID-number was missing in my solution. So it didn't work. But now it does.

Thanks a lot!

What do you mean by complete?

If you are talking about null you can with a summarize tool count the nulls in the column.

If the numbers need to be in a specific range then something more elaborate would be needed.

Regards

Hi,

I need to check if the numbers are really in a row, like: 1,2,3,4,...

And if one number is missing I have to create an output for the user to add it.