Skip to Content
avatar image
Former Member

Ignore null values into S&OP

Hi Guys,


Product table in S&OP is updated with values "NULL" this is because no data in source. If source field has no data i want to hardcode it to 'undefined'.  I had below mapping restriction in HCI Data flow mapping but its not working. Pls suggest guys?

nvl(ltrim_blanks( rtrim_blanks(DetATINN.SUBBRANDID)), 'UNDEFINED')

Regards,

Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 25, 2016 at 06:01 AM

    Rajendar,

    Try ifthenelse(DetATINN.SUBBRANDID = NULL,'UNDEFINED',ltrim_blanks( rtrim_blanks(DetATINN.SUBBRANDID))).

    Thanks,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded