back to forum.

Topic: How to ignore NULLs?

Topic by
chiaochi

2011-03-18
18:45

How to ignore NULLs?

Sorry, I'm still new to the program... can someone share with me how he/she have "Matching Analyzer" ignore NULLs, assuming there are no NULL value in the dictionaries.

Thanks in advance.

George

Reply by
kasper

2011-03-18
20:27
Fortunately that's quite easy :) Just add a "Not null" filter in the "Filters" tab. Then go to your "Matching analyzer" tab and click the filter button in the upper right corner. Select "Not null -> Valid". Then only rows that don't contain null values will be piped to the analyzer.

Reply by
chiaochi

2011-03-21
18:05
Ah... I was wondering how to use that filter button. Thank you!

I've tried different data profiling tools including Talend and Ataccama's DQ analyzer and I got to say DataCleaner is the best one. Please let me know if help is needed, I'm would be happy to help making DataCleaner better.

Reply by
kasper

2011-03-21
21:11
Thank you very much for the kind evaluation :)

Help is in deed welcome! There are a couple of different ways you can contribute - if you have Java coding skills, then contributing to the code would be obvious. Also we lack resources to help build the documentation so that's also an area where we would love involvement. Or maybe you have even something different in mind. All ideas are welcome! :)

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.