Hi a m,
You need to Create a Full Outer Join To Get This.Your Secondary Data source should be Primary as You may like to use All Transit Values for A like A, B, C.
For A, 100
If It Helps, Pl Mark it Helpful and CORRECT to Close Thread
Full Outer.twbx 8.4 KB