A space is considered as Null??

[former_member283645]

Hi Experts,

I need to ask this as i dont have access to MDM at the movement.

If the incoming file is a xml file.

Incoming value <DESCRIPTION> <\DESCRIPTION>   (One space in the tag)

my record in mdm has DESCRIPTION = Raw material

Now, If i load this incloming file, will my DESCRIPTION field have

a) Raw material replaced with a single space

b) Raw material

c) Raw Material replaced with a blank

Secondly,  I am aware of an option in import map 'set null value interpritation'

it says either Ignore or Overwrite with Null. But here the incoming value is not NULL but is having a value which is  'a space'. so this option is not applicable here. Is my understanding correct??

Please Help.

Kind Regards

Eva

[Former Member · Accepted solution]

Hello Eva,

If a field value contains only Space then the import manager will consider it as a NULL.

Now there are two cases.

1. when the set null value interpretation" property is set to Ignore.

    Your Description field will remain as Raw Material

2. when the set null value interpretation" property set to Overwright.

    Your description field value will be changed to <Null>

Just to add to the above points,

You can also see the description field values in the Import Manager.

1. Select the Match records tab.

2. In the record matching grid you can see that the description field values are shown as Null (Even if the description field has space in your xml file)

Rgds,

Prasad

[former_member283645 · Accepted solution]

Hi,

So a space in the incoming XML is considered as NULL in MDM.

<DESCRIPTION>   <\DESCRIPTION>

If thats true then obviously the 'set null interpritation' option comes into picture.

Kind Regards

Eva

[Former Member · Accepted solution]

Eva,

Yes, in MDM, if any field, which contains blank/Single Space/Multiple spaces, is considered as NULL. And to handle null values, we need to set Overwrite existing values with NULLs value for Default NULL Interpretation property in the configuration of Import Manager.

Thx/ -Tarun

[Former Member]

Hi Eva

I think it will set as blank or null, it means now here there is no value, but in future there will be some value in this position, so a kind of memory space is alocated for this value.

Regards

Nitish Sharma

[former_member226173]

Hi Eva ,

I think it totally depends on your requirement .

You can definetly update the Description with a Space if needed ,

Else you can place a check in the PI system to see if there are any spaces which are in the file and change it something meaning full .

Regards,

Vignesh