Question how to create stage / union

Hello,
i need to create an union with 2 tables, i can't find how to create a stage/mutualization as said in the help.
Can you help me

Thanks

Hi,

Stages exist starting with S18.

To create a stage from scratch, drag and drop a Schema in the Mapping.
If you want to create a stage on an existing Mapping and reuse existing transformations you can also drag and drop the Schema on an orange link.

After that, in order to create a new field you can:
- drag and drop a source field on the Stage
- select the stage and click the Field icon appearing on the left of the Stage

When you want to add a UNION you have you:
- select the Stage and click on the "New Set" icon on appearing on the left
- set the union Expression in the Expression Editor such as [A] union where A and B are the names of your stage
- fill the expression for each field in the new Set

I hope this helps

Best

Hi,

I don't find how to do or use 'schema', 'stage'. Could you please explain it with print screen and step by step?

Thanks

Hi,

you have a detailed how-to in the first Stambia tutorial in the chapter about mutualization of transformations.
see attached screenshot (even though it is from the french tutorial).


I hope this helps

Best