Skip to main content
Solved

I am trying to test an entire field to see if there are any populated values.

  • September 22, 2017
  • 4 replies
  • 24 views

It is a large data set. If there are no values, I want to send the data to a writer, if there are any values, I want to go to the terminator. My issue is that the data set is large and using a tester or attributeValidator isn't work because values are getting to my writer before validation is complete.

Best answer by ciarab

Try the feature holder as it will hold all the records until the last one arrives. So your null records should hit terminator before the last correct record arrives at the feature holder.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • September 22, 2017

What reader format is being used. If it is a SQL enabled format, you could use the WHERE clause on the reader to determine if any features exist with a value.


  • Author
  • 1 reply
  • September 22, 2017

What reader format is being used. If it is a SQL enabled format, you could use the WHERE clause on the reader to determine if any features exist with a value.

It is an Esri Geodatabase that is being used for the reader

ciarab
Contributor
Forum|alt.badge.img+9
  • Contributor
  • 167 replies
  • Best Answer
  • September 22, 2017

Try the feature holder as it will hold all the records until the last one arrives. So your null records should hit terminator before the last correct record arrives at the feature holder.


erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • September 22, 2017
It is an Esri Geodatabase that is being used for the reader
That reader should have a WHERE clause.

 

You could use something like:

 

"0 = (Select count(*) from table where attribute is not null)"

 

That would have the database check if the table contains any not null attributes.