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

[amauryvanespen · 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

[shyam_uthaman]

I don't have a system to check this right now but try removing the mappings in the union coming from Join_A_X first. This would make sure that the union has nothing to do with the join.

Then remove Join_A_X.

Let me know if that works.

[former_member307980]

Hi, Shyman. Thank you for your reply.

Your suggestion seemed to work, however, in the union node I 'auto map by name' and propagated everything up and activated the model. I then traced the lineage for one column in the union node- in the union node it was showing that the specific data element I was tracing lineage for was coming from the remaining three join nodes (so your option worked in this respect). However, when I traced the lineage from the union node to the three remaining join nodes, the specific column I was tracing was only coming from one of the join nodes, not three, as represented in the union.

Thoughts on this?

For my solution I ended up breaking apart the model and propagating everything back up through the model, time consuming, but it worked.

[shyam_uthaman]

Hi Jared,

What you describe is a strange behavior but HANA Studio/Eclipse does do strange things sometimes when you remove fields. I have faced similar bugs in the past and decided to break and rebuild instead of wasting more time and patience on understanding the bug.

I know its not the answer you're looking for but I dread removing/disabling fields as it does strange things once in a while that can not be logically explained - at least not by me.

Regards,

Shyam