Skip to Content
Former Member
May 06, 2010 at 05:45 PM

Ignore NULLs when partitioning a field in Import Manager



I'm creating a pretty complex import map, which loads data from a multi-segment XML file. I have to use partitioning to combine a few fields in order to complete the mapping. The problem I'm facing is that in many cases, one or more of the fields I'm partitioning have NULL values. Because of the partition the list of unique values for the combined field becomes very long, but it's mostly filled with partition results that have a value in the first level of the partition, and NULL in all the others -- these are values I simply don't need, and they outnumber the "real" values.

Any knows if there's a way to make Import Manager ignore NULL values when create a partition?