Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator II
Creator II
‎2025-03-07 02:08 AM

datamodel help

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.

Krish2459_58_1-1741331192641.png

 

 

Labels (2)
Labels
required output.xlsx
316 Views
1 Reply
marcus_sommer
MVP
MVP
‎2025-03-07 04:23 AM

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.

288 Views
0 Likes