Using the Magic ETL Python scripting tile

Access to the Python scripting tile, as seen in the following screenshot, is a paid feature for Magic ETL. Contact Domo to have the tile activated. It enables you to run Python code as part of an inline data pipeline without the need for a Python server, as that is all handled by Domo Magic:

Figure 15.1 – Python scripting tile in Magic ETL

This is a powerful feature to handle edge cases that the standard Magic ETL doesn't cover. To get some experience in using this feature, let's walk through a data cleansing example that can be applied to any category attribute in a dataset, as follows:

1. Click the DATA main menu icon, then click on the DataFlows icon in the left-side toolbar, then click the ETL icon in the MAGIC TRANSFORM sub-menu.
2. Change the Add DataFlow Name value to Cleanse with Python.
3. Click, drag and drop an Input Dataset tile using the Opportunity CH7 dataset, a Python Script tile...