Multiple values from multiple data providers

[DataWife]

Hi,

I have two data providers, one shows for example five records in the first data provider with the same key ID, and five records in the second data provider with that key ID. I have merged the two data providers on the key ID, and created a new variable, based on this merged dimension, on a variable from the first data provider. When I add this new variable to the second data provider, it only shows five records when I would expect it to show 25 i.e., the five from the first provider against each record in the second provider. How do I get it to do this?

Thanks