Hi! I am looking into way to explode dataset based on source files and repeat main records

[PiyushPWC]

In the example below.. Input 1 is the main key... and based on input 2... I want the Input 1 dataset to repeat based on multiple combination available..  

This is expected outcome -  where.. A1 is replaced with Product 1,2,3  in different rows and data is repeated for ABC and XYZ. and similarly relevant products are picked for LMO for B1

Let me know how to go about it, it would be great if i can get some sample flow thanks. 

[PiyushPWC · Accepted solution]

Hi, Ignore this one. I tried join tool and it worked out fine.