Null value transform function
Introduction
The null value transform function is used to replace the value of a source field with null.
Adding a null value transform
Step 1 In your process flow, access settings for your map shape:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FaXEkDoJIsEmKG9b1JSTu%252Fnull%2520transform%25201.png%3Falt%3Dmedia%26token%3D73b3cec9-ff2f-4ba8-8a9b-736cbac97f5f&width=768&dpr=4&quality=100&sign=6917dd&sv=1)
Step 2 Select the add transform button for the required mapping rule - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252F4HHW2FXxlVMvncKxiolp%252Fnull%2520transform%25202.png%3Falt%3Dmedia%26token%3Dbfd8cdb9-6f34-448c-98a8-5078c6b8e309&width=768&dpr=4&quality=100&sign=7048af0&sv=1)
Step 3 Click the add transform button:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FQANVCDb8TeHqq9goVe6J%252Freplace%2520transform%25202.png%3Falt%3Dmedia%26token%3Dda01cae6-c482-407c-ac3d-16182205b12f&width=768&dpr=4&quality=100&sign=91ba7740&sv=1)
Step 4 Click in the name field to access a list of all available transform functions, then select null value from the other category:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FsasgJPhqgdTnaz95p2vh%252Fnull%2520transform%25203.png%3Falt%3Dmedia%26token%3D920a2d7a-842e-4119-a19a-2ba2915baf73&width=768&dpr=4&quality=100&sign=c9d1c01b&sv=1)
Step 5 Click the add field button:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FzExy6BP7mklOVKlVqr5b%252Fnull%2520transform%25204.png%3Falt%3Dmedia%26token%3Decf3aceb-cf51-446e-9bcf-67e5a9ff510a&width=768&dpr=4&quality=100&sign=1bd508c3&sv=1)
Step 6 Click in source fields and select the source field to be used for this transform:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252Fn2zTtKUQsZnrkcbYfTzK%252Fnull%2520transform%25205.png%3Falt%3Dmedia%26token%3D7681d4ca-609d-4ecb-b61a-68d9dcb6818e&width=768&dpr=4&quality=100&sign=d25085e&sv=1)
Step 7 Accept your changes (twice).
Step 8 Save the transform. You'll notice that the transform icon is updated to indicate that a transform function is present for the mapping row - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252Fu1Pk3JF1dmaY2yF8IqOA%252Fnull%2520transform%25206.png%3Falt%3Dmedia%26token%3De19c466b-c5bc-421a-9aff-3abdb2baadf3&width=768&dpr=4&quality=100&sign=a96a6aa3&sv=1)
Last updated