Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to separate a concatenated fact table and build link table ?

  Here are  2 tables that are concatenated.  Requirement is to remove the concatenated fields into another link table and create generic keys. 

How do you separate a concatenated table and link with generic keys ?


Details                                         Plan 

OrderID                                Company 

Item Number                         Brand 

Line Type                               Market


Here is a script to concatenate .  The issue is  the  concatenated 'Details'  table only shows up in data model with this concatenate statement.  If I make any changes to this script the 'Details' table does not show at all. What is causing this ?


CONCATENATE (Details) load

resident Plan;

drop table Plan;

0 Replies