Regarding link between two tables

[#1]

Hello Friends,

I appreciate your time. I have 2 tables one with Products,category and subcategory. My 2nd table with Sub category and amount .

When I run separately the two tables,they are working fine with proper values. But after linking the products values get merging up.

I am not pretty sure how to connect these 2 tables. I am looking for a key to connect these tables.

Attached the sample excel source with 3 tabs for 3 different tables.

I need to have a data model of table1-->table2-->table3

Please let me know your valuable solution.

Thank you again!

Kiruthiga