Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
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