Convenience function to convert all fields in the table using a common function or mapping. See also convert. The value of a specific field can be referenced using {_value}.
Example
Removing the "a" character from all field values:
Example Input
| dim_A | dim_B | metric_1 |
| abc | ddd | 111 |
| EEE | ABCaaa | 222 |
| aaBAa | FFF | 333 |
Example Output
| dim_A | dim_B | metric_1 |
| bc | ddd | 111 |
| EEE | ABC | 222 |
| BA | FFF | 333 |
I Ain't Afraid of No Code!
[
[
"convertallx",
{
"subtable": null,
"expression": "{_value}.strip('a')",
"_comment": null
}
]
]param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str expression: Expression to be performed on all fields’ values.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.