Ignore null values into S&OP

[former_member367475]

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

[Former Member · Accepted solution]

Rajendar,

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

Thanks,

Kiran

[former_member367475 · Accepted solution]

Thanks Kiran for quick reply.

I got below error message

WARNING        Column [SUBBRANDID]: ERROR          Column [SUBBRANDID]: Comparison data type is UNKNOWN ERROR          Column [SUBBRANDID]: Cannot convert <null> to <FUNCANY_TYPE>.

[Former Member · Accepted solution]

Error?

[former_member367475 · Accepted solution]

Solved with below logic ifthenelse(CatDescr.SUBBRANDID is null or CatDescr.SUBBRANDID = '', 'UN', CatDescr.SUBBRANDID)