Sorry if this or similar has been asked before.
I'm looking to replicate an existing macro process on knime, which is constrained by the layout that has been asked for.
Eg; I have two data tables, one with material and sales. One with a list of components used to make said materials (but not for all materials).
1 - Material Sales
2 - Material Component
Where some materials have multiple components.
I would like to join the tables in such a way that both components are shown, such as:
Material Sales Component
1 x 11
3 z 31
3 z 32
Any advice is much appreciated,