GoldenGate Conditional Replication of Data Question

We are using Oracle GoldenGate Service Manager 21.3.0.0.0.

We are attempting to set up GoldenGate replication where the source data has multiple table/column combinations into a single table/column on the destination side. For example we have source.tableA.columnA and source.tableB.columnA. Both of these map to destination.tableC.columnA but it’s conditional based on the value of source.tableD.columnA where if that value is X, the destination data comes from source.tableA but if it’s Y the value comes from source.tableB. I have tried every combination of conditions that I could come up with to create this type of replication but nothing I’ve come up with seems to capture data the way we need.