I have two branches : Branch A contains ID property (one ID per record) and some other properties. Branch B contains multiplicated ID property and some others. Let's say branch A has 3 records with IDs: 1,2,3 and branch B has 30 records with each ID (1,2,3) multiplicated 10 times. How to merge both branches and get final table containing 30 records with all the properties from branch A and B ? When I use MergeData component, I only get only 3 records back (I select "Append or Create" otpion).

Best regards,

Aleksandra