datamodel help

[Krish2459_58]

Hi, Could yoiu please help with below scenario.

I have product table and unit link table.

Product category is divided into HLE and LEA in main product table. But where as in unit link table 

product ZSL43644 is mapped to 0ZL22449 in which product ZSL43644 should has landlord ref as 000Z2616.

Please see the required output session below.

[marcus_sommer]

After a crosstable-transform of the link-table they could be joined/mapped to the product-table - which could add there the unit ref - but there is association between the unit ref and the landlord ref and therefore the missing landlord-information couldn't be set. To get this you will need more/other data.