Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

how to achieve data association for multiple columns from data load editor ?

Dear All,

I had 4 tables called tab1, tab2 , tab3 and tab4

tab1 has columns : customerid, cust_name, cust_age , app_id

tab2 has columns : appname , app_id, app_version

tab3 has coulmns :  customerid, cust_role , device_id

tab4 has columns :  device_type , app_download 

tab5 hs columns :  customerid, cust_address, cust_designation 

Now I want to associate tables / design ER model as below

customerid of Tab1 will associate to customerid of Tab3

app_id of Tab1 will associate to app_id of Tab2

device_id of Tab3 will associate to device_type of Tab4

customerid of Tab1 will associate to customerid of Tab5

 

If i am loading tables using Data Manager I am able to auto associate and seems fine
but I want to do same thing from data load editor 

Kindly suggest how to achieve same

Labels (2)
2 Replies
Highlighted

check this way, In the Tab3 table rename the field like device_id as device_type

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III
Contributor III

But to how to associate other keys like customer_id , app_id etc. because by loading from Data load editor it forms synthetic keys .

By doing qualify and unqualify things it does not form any associations .