Data Mangement Mapping

Moatasem Shebl

Hello Leaders,

I am using PBCS data management i have a blank rows in my source file its rejected during the data load i want to map that blanks in my data load mapping

Note : Blanks = empty cell in my source file

I tried the mapping as per the screen shot did not work

Thank You

JohnGoodwin

You could add a fill expression

This will set any null values to 0 then you can map.

Alternatively you can just use a SQL mapping to map Nulls, for example

Cheers

John

JohnGoodwin

You could add a fill expression

This will set any null values to 0 then you can map.

Alternatively you can just use a SQL mapping to map Nulls, for example

Cheers

John

kafka89

You could also use import script and then have only one like mapping for this dimension

def FillNullEntity(strField, strRecord):

    if strField is None or strField == " " :

        return "No Vehicle"

    else:

        return srtField

JohnGoodwin

Not available in the cloud though.

Moatasem Shebl

Thank you for your reply but no custom script in the cloud

WPaffhausen

Hello,

You can also use <BLANK> there is a nice table on expressions in the document.

But please note that <BLANK> does not mean NULL.  So there are a lot of things to consider.

Thank you,

Wayne

Moatasem Shebl

Hello ,

Thank you for your reply

As per the admin guide <BLANK> Processes only rows that contain the blank character (space), my issue is i have one column in my source file contains some EMPTY rows so because of empty rows i can not use <BLANK> also because of there are some rows has data i can not use the Fill=0 in my import format so the best solution as per Mr Goodwin reply is to use SQL mapping "CASE ..WHEN"