Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView App Dev

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.

Who Me Too'd this solution

Not applicable

Its nothing but Combining the common fields which makes synthetic keys

Ex:

Tab1:

Load

Country,

Region,

Sales,

Products

From --------------;

Tab2:

Load

Country,

Region,

Customer,

Outstanding

From ---------------;

If you load these 2 tables directly your script contains synthetic keys (Country and Region-- common in both tables)

Sol:

Tab1:

Country&'-'&Region as Key    //Composite key

Sales

Products

From --------------;

Tab2:

Country&'-'&Region as Key   //Composite key

Customer,

Outstanding

From --------------;

View solution in original post

Who Me Too'd this solution