Mapping or Remove value from field

[AlexWest]

Hi guys!

I have a field that I'm mapping. But there is a value that I have to make as Null().

The value is calling "Denies" but there is a value "SUCCESS" in this field , so I need to Null it, but just replacing is not working because the Value will be appeared everytime.

Is there any solution to make script that will remove (Null) the SUCCESS value?

Thanks!

[Mark_Little · Accepted solution]

Hi,

I would change the value in to your mapping load, something like

Mapping Load

Key,

IF(Field = 'Success', Field, NULL()) as Field

From ...

[AlexWest]

Thanks! It works! 😃