Ignore NULLs when partitioning a field in Import Manager

[Former Member]

Hello.

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?

Thanks,

Alon

[former_member205403]

Hi,

in the "Map Fields/Values" tab, in the field mapping pane right click on the source partition field and set " set Flat null handling"/" set hierarchy null handling" parameters. if this does not fullfil your requirement then you can also try by right clicking and setting "Value conversion filter" on the source partition field. And use "replace" filter and replace "NULL" with either space or your desired value.

Hope this helps...kindly revert with the result or you face any issue.

Regards,

Shiv