Articles in this section

See more

Meta Operations - "metaaddfield"

Avatar
Tom Sherwood
  • Updated
Follow

Adds an arbitrary column from meta information (column has distinct value for all rows).

Example 1

metaaddfield_example_1.png

Example Input 1 
Simple field, would extract {"adverity_client_name":"Tenant#1"}:
dim_A dim_B metric_1
AAA DDD 111
BBB EEE 222
CCC FFF 333
Example Output 1
dim_A dim_B metric_1 new_field
AAA DDD 111 Tenant#1
BBB EEE 222 Tenant#2
CCC FFF 333 Tenant#3

 

Example 2

metaaddfield_example_2.png
Example Input 2
Nested Field, would extract {"custom_meta_information":{"source_directory":"uploads"}}:
dim_A dim_B metric_1
AAA DDD 111
BBB EEE 222
CCC FFF 333
Example Output 2
dim_A dim_B New_Field metric_1
AAA DDD uploads 111
BBB EEE uploads 222
CCC FFF uploads 333

 

I Ain't Afraid of No Code!

Example 1

[
    [
        "metaaddfield",
        {
            "index": null,
            "subtable": null,
            "metaname": "client_name",
            "fieldname": "new_field",
            "_comment": null
        }
    ]
]

Example 2

  [
    [
        "metaaddfield",
        {
            "index": 2,
            "subtable": null,
            "metaname": "custom_meta_information.source_directory",
            "fieldname": "new_field",
            "_comment": null
        }
    ]
]

param int index: Location index of the new field. Default is None: adds field at the end.

param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).

param str metaname: The source field in meta header. Nested dictionaries can be navigated via ..

param str fieldname: The new field to be created

param str comment: A comment that will appear in the Transformation UI.

Related articles

Comments

0 comments

Article is closed for comments.