convertallx
On this page
Convert all the values in a data extract using a Python expression.
Introduction
Use the convertallx instruction to convert all the values in a data extract using a Python expression.
Creating a custom script transformation using the convertallx instruction
To create and configure a custom script using the convertallx instruction, follow these steps:
-
In the Instruction step, select the convertallx instruction.
-
To configure the custom script instruction, fill in the following fields. Required fields are marked with an asterisk (*).
- Python Expression
Enter a Python expression to use as a converter. For a full list of compatible converters, see the Python documentation.
- Fail on Error
Select this field to stop the transformation instruction if an error occurs.
Example
Transformation configuration
To remove leading and trailing characters from values in the table, use the Python strip function.
- Python Expression
{_value}.strip('_')
Data table before transformation
Scroll horizontally to see the full table.
Campaign | Ad Group | Clicks |
|---|---|---|
_brand | media_ | 75856 |
_outreach | weekend_ecommerce_ | 38753 |
_organic_growth | socials_ | 99651 |
Data table after transformation
Scroll horizontally to see the full table.
Campaign | Ad Group | Clicks |
|---|---|---|
brand | media | 75856 |
outreach | weekend_ecommerce | 38753 |
organic_growth | socials | 99651 |