[resolved] Ignore null values in tAggregateRow

One Star

[resolved] Ignore null values in tAggregateRow

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?
Seven Stars

Re: [resolved] Ignore null values in tAggregateRow

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 ("") ...
Highlighted
One Star

Re: [resolved] Ignore null values in tAggregateRow

Oh, that makes sense. Avm_point should have been an integer. Thanks! It's good to know that strings aren't read as null, though.
One Star

Re: [resolved] Ignore null values in tAggregateRow

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.