Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Mapping or join

Hi All,

I have two tables.

In one table i have A,B,C,D.....K

In second table i have A,B,C,D,L.

Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.

Now for this what i need to do join or link the tables or Mapping.. I am not sure.

Can you please help me on this.

Thanks,

Bharat

1 Solution

Accepted Solutions
qlik4asif
Creator III
Creator III

I have changed code

PFA

View solution in original post

32 Replies
gerry_hdm
Creator II
Creator II

have you a example . what is the Output ?

qlik4asif
Creator III
Creator III

You Can create composite key for Fields A,B,C,D in both tables

Now two tables will be connected with Composite key,

Dont forget to use autonumber after creating Composite key for better performance.

bharani8
Creator III
Creator III

Below link gives u the required info..

how to create composite key

bharatkishore
Creator III
Creator III
Author

Hi Asif,

I created a composite key now do i need to use left join and give auto number in second table.

can u please tell me how to do it.

bharani8
Creator III
Creator III

Chk this link.. U will get clear idea...

After u create the composite key, both the tables gets joined with the composite key.. No Joins required separatly..

how to create composite key

qlik4asif
Creator III
Creator III

Tab1:

Load

Autonumber(A&B&C&D) as %key,

..

...

..

K

From ........file;

Tab2:

Load

Autonumber(A&B&C&D) as %key,

L

From ........file;

Now the Both tables will automatically get connected,

You can see in Table viewer


bharatkishore
Creator III
Creator III
Author

Please find the attached app.

Now can you tell me how can i store this into qvd.

bharatkishore
Creator III
Creator III
Author

Hi Asif,

I have tried your method.


Can you please tell me how can i store this into qvd.. PFA app.

qlik4asif
Creator III
Creator III

Store Tablename into Path.qvd(qvd);

Tablename - which table you want to store in QVD

Path - Loaction to store QVD