on 08-25-2016 6:55 AM
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
Rajendar,
Try ifthenelse(DetATINN.SUBBRANDID = NULL,'UNDEFINED',ltrim_blanks( rtrim_blanks(DetATINN.SUBBRANDID))).
Thanks,
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.