Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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