topic datamodel help in App Development

datamodel help

Krish2459_58 — Fri, 07 Mar 2025 07:10:10 GMT

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.

Re: datamodel help

marcus_sommer — Fri, 07 Mar 2025 09:23:18 GMT

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.