Multiple Field Mappings in Python

Open Q & A SDKs
1

Hello. Just joined here. How can I write multiple field mappings in Python?

Thank You!

2

Hi @livingst!

To create multiple filed mappings, it’ll look like this :smile::

  rs.FieldMapping.mapping(
    name="transformation1",
    input_fields=[
      rs.FieldMapping.input_field(
        field_name="first",
        if_missing="PASS",
        is_drop=True,
        param="first"
      )
    ],
    output_field=rs.FieldMapping.output_field(
      field_name="first", sql_expression="SHA256(:first)",
    )
  ),
  rs.FieldMapping.mapping(
    name="transformation2",
    input_fields=[
      rs.FieldMapping.input_field(
        field_name="last",
        if_missing="PASS",
        is_drop=True,
        param="last"
      )
    ],
    output_field=rs.FieldMapping.output_field(
      field_name="last", sql_expression="SHA256(:last)"
    )
  )
]

You can read more on our [python docs](https://docs.rockset.com/client/python/)