span8
span4
span8
span4
Let's say I have a table like this:
AttributeA | AttributeB |
some value | some value |
some value |
|
some value |
|
some value |
|
some value |
some value |
And I want to summarize how manynullsare in each column (attribute) of a table like this:
AttributeA has 2 blanks / nulls.
AttributeB has 1 blanks / nulls.
What is the best way to count how many nulls are in a given column of a table?
@dmatranga one way would be to use the attributevalidator in 2016 to test for attributes that have a value.This will push all the records that fail your null test through the failed port.( If you do not have 2016 or later you could use a tester to test your attribute is missing,null,empty)
If you then use the list exploder to split where it has nulls in more than one column,add a statistics calculator to count the number of failed messages
The Failed column will now give you a total count of Nulls for each,if you wanted to use a duplicate filter on the Failed column to remove the multiple records you will be left with a single record that contains the Failed Value and Validation Message you need.
hope that helps!
How can I add an increment at each change in an attribute value.2 Answers
How to properly read ESRI Shapefile attributes that are in another language5 Answers
Decomposing attribute table.1 Answer
compare field attributes (of same table)6 Answers
SDE - uncheck Allow Null property in table creation via FME1 Answer
© 2019 亚搏在线Safe Software Inc |Legal