Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
claudialet
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
Company,
Brand,
Market

resident Plan;

drop table Plan;

0 Replies