This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have 3 tables and my requirement is,
1.Cust_no and Cust_name from A and B table should map
2.Cust_no from B and C table should map
Please assist me
A:LOAD Cust_no , Cust_name, Dept, City, PhoneFROMC:\Users\257679\Desktop\Applymap.xlsx(ooxml, embedded labels, table is Sheet1);
B:LOAD Cust_no, Address, regionFROMC:\Users\257679\Desktop\Applymap.xlsx(ooxml, embedded labels, table is Sheet2);
C:LOAD Cust_no, Cust_name resident A;
To avoid Syntethical keys you should make sure that only one field from each of you tables is linked to another table.
But why do you want to split your source into three tables? Why not just load it as one table?
As per your post do the following thing .I dont know why you want to do like this.
To Remove Synthetic key always rename the field which you doesnot want as linking with other table.
Cust_no as CustNo1, Address, regionFROMC:\Users\257679\Desktop\Applymap.xlsx(ooxml, embedded labels, table is Sheet2);
C:LOAD Cust_no as CustNo1, Cust_name as Cust_name1 resident A;
Can you please Attach the Sample Application.
Please tell me Why you are creating a new table C
1.Cust_no and Cust_name from A table should map to Cust_no and Cust_name in B table
2.Cust_no from B should map to Cust_no in C table
Using common field as key in your table can avoid creating synthetic keys
LOAD * ,Cust_no&Cust_name as key Inline [
Cust_no,Cust_name, Dept, City,Phone
123, A ,Sales ,Bang ,0908088
LOAD Address,region,Cust_no&null() as key Inline [
LOAD Cust_no&Cust_name as key;
My friend CustName is not there in table B, I still confused why you want resident table C:??????
Kindly expalin in brief so that it would be more clear or else share a demo file for further help.