When creating or editing a dataset in Nexla UI, you can specify how incoming records from data sets should be transformed into outgoing records. Nexla supports different modes of specifying these transform rules.
You can view these choices as different tabs like the screen above when you launch a dataset creation or edit workflow.
Pass-Through Mapping is the easiest to use. Simply toggle a switch to send all data through without any transformation.
Transform Builder provides simple dropdown elements with which you can apply powerful built-in Nexla operations that allow for a wide variety of modifications. You can even combine these operations as Compound Transforms. We'll look at Transform Builder in this section.
In this section we will dive deeper into Transform Builder transforms.
How do I create rules using Transform Builder?
1. In one of the Datasets pages select the data set you wish to transform. Click the blue paper airplane icon in the top right corner.
2. You will be redirected to the transforms editor. In the left panel, select the attribute you wish to transform by clicking the attribute’s checkbox.
3. [Optional] From the first drop down menu in the middle panel, set the format of your attribute.
4. From the second drop down menu, add the transform you wish to make. Click here for a list of the transforms Nexla can make. Don’t see your needed transform? Let us know at email@example.com or click on custom code tab to drop in your own code for the transform you wish to make or reuse an old custom transform.
*Before inserting your custom code, please work with Nexla's solutions team to test and validate your custom transforms.
5. [Optional] From the third drop down menu, add a filter of your choice. When you’re done applying the desired transforms, select Add to Draft and send it off to your desired destination.