All Records with similar IDs

[Anonymous]

Hi All,

I am new to qlikview and facing below problem:

I have few tables which are resident from different tables, I am concatenating them all to be used in a third table for some calculation.

For a particular condition I need all the records having similar ID from below 2 tables. Eg.

Tab1:

Load a, b, ID

Resident Table1;

Concatenate (Tab1)

Load 1,2,ID

Resident Table2;

and concatenation goes on for a few more tables. (Other tables don't have this field "ID" and is not needed even).

I want all the records which will have similar IDs in Table1 and Table2. How can I accomplish this, any suggestions?

Thanks!

[Anonymous]

Thanks for the quick response.

But I need all other fields as well and not only the matching fields.

[kaushiknsolanki]

Hi,

     Use the join keyword only.

Regards,

Kaushik Solanki

[#4]

try to use

Outer join

or join  both are same

[Anonymous]

Can you please elaborate a little?

Thanks for you time.

[kaushiknsolanki · Accepted solution]

Hi,

     Below code will give you data from both the table which are linked as well as which are not linked.

Tab1:

Load a, b, ID

Resident Table1;

Join

Load 1,2,ID

Resident Table2;

Now here out out will contain a table with fields a,b,ID,1,2.

Where ever the ID is matched you will see the data and where ever it is not matched you will see the null.

Regards,

Kaushik Solanki

[Anonymous]

Thanks everyone for all the help!!!

[Anonymous]

Just one more question, there are other tables which don't have this column "ID" or any other join column, how the data will be pulled from those tables?

[kaushiknsolanki]

Hi,

     There should be a linking between those table, other wise on what basis you will link them?

     May be not ID field but some other common field.

Regards,

Kaushik Solanki