Remove a single join node under a union node?

[former_member307980]

Experts,

Scenario- I am currently building a model and have recently been told I need to remove Join_A_X, and map projection Table_A straight to the union node. When I remove the join, it removes ALL of the output from Table_X within the UNION node. I assume it is because Join_A_X was the first object created within the UNION node.

Is there a way to remove Join_A_X, and keep the result output for the remaining three joins from Table_X in the UNION?

Thank you in advance

Jared

[Amaury_Van-Espen · Accepted solution]

Good afternoon jared.siebenaler

In HANA Studio, right click on the node you have to remove

then choose the source node

Check the mapping and run

Regard

Amaury