topic Re: All Records with similar IDs in QlikView

All Records with similar IDs

Anonymous — Mon, 29 Jul 2013 07:03:34 GMT

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!

Re: All Records with similar IDs

Anonymous — Mon, 29 Jul 2013 07:47:11 GMT

Thanks for the quick response.

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

Re: All Records with similar IDs

kaushiknsolanki — Mon, 29 Jul 2013 07:58:43 GMT

Hi,

Use the join keyword only.

Regards,

Kaushik Solanki

Re: All Records with similar IDs

Mon, 29 Jul 2013 08:01:55 GMT

try to use

Outer join

or join both are same

Re: All Records with similar IDs

Anonymous — Mon, 29 Jul 2013 08:09:35 GMT

Can you please elaborate a little?

Thanks for you time.

Re: All Records with similar IDs

kaushiknsolanki — Mon, 29 Jul 2013 08:14:49 GMT

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

Re: All Records with similar IDs

Anonymous — Mon, 29 Jul 2013 08:28:17 GMT

Thanks everyone for all the help!!!

Re: All Records with similar IDs

Anonymous — Mon, 29 Jul 2013 08:42:34 GMT

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?

Re: All Records with similar IDs

kaushiknsolanki — Mon, 29 Jul 2013 08:44:15 GMT

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