Please see the attached image. If it's not clear, I am trying to use tAggregateRow to find counts of all records and all non-null records in a file, grouped by fips_code. I know that ir_id is never null, but avm_point potentially has some null values. When I run this job, regardless of whether I have ignore null values checked or not, I get the full row count for each field. Am I not using ignore null values in the intended way? Any ideas how I can accomplish what I'm trying to do?
You say that you're trying to count records in a FILE? Is avm_point a String? tFileInput components generally don't ever read Strings as null but rather as empty Strings ("") ...
Hi, If my input column is string then how can i get count(distinct) values of that column ignoring null values. i tried with taggregaterow component, but it's reading null value as a distinct value, can you please help on this to suggest best way to handle it. Thanks, Harsha
