# Stream Schema Merge

## <img src="/files/JRdCIrPXrFT9ISsrzMmW" alt="" data-size="line"> Stream Schema Merge

### Description <a href="#description" id="description"></a>

The Stream Schema Merge transform merges multiple inputs with different structures and creates a combination of fields.

{% hint style="info" %}
Tip: If the streams to merge contain fields with the same name but different types, these fields with be combined into a single field of type `String`.\
If you want to make sure fields keep their original data type, make sure to convert them to identical types. e.g. through the `Metadata` tab in the [Select Values](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/selectvalues.md) transform.
{% endhint %}

| Hop Engine | <sup>✓</sup> |
| ---------- | ------------ |
| Spark      | ?            |
| Flink      | ?            |
| Dataflow   | ?            |

### Options

| Option         | Description                                                                                                                                                                                                                                                                                     |
| -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Transform name | Name of the transform.                                                                                                                                                                                                                                                                          |
| Transform      | The list of transforms to merge. Fields with identical field names in two or more of the input streams will be combined into a unified field (data type is kept if identical, converted to `String` if different). All fields from all of the input streams will be added to the output stream. |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/streamschemamerge.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.