Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
satyaban
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 (1)
2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
satyaban
Contributor III
Contributor III
Author

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 .