topic Re: Join tables in QlikView

Join tables

Thu, 27 Sep 2012 17:19:02 GMT

Hello All,

I need to know the simple process of joining 3 tables:

table A --------------> table B<----------------Table C

And I don't want to have any Sync table.

Thanks,

Re: Join tables

spsrk_84 — Thu, 27 Sep 2012 17:28:47 GMT

Hi,

Create composite key in each table if you have more than one key in common between the three tables.Such that u can elminate the Synthetic keys/tables.

Thanks

Shiva

Re: Join tables

Thu, 27 Sep 2012 17:49:44 GMT

Here is the case:

I select my table from database and I create the composite key in the same Select comand ,Or I have to create a linked table?

Thanks for your help?

Re: Join tables

Thu, 27 Sep 2012 18:13:13 GMT

When I create a composite key I get an error message like this:

SQL ###f- SqlState :$1000,Errorcode:923 ....................... keyword was not found where expected SQL select.....

Any Idea?

Re: Join tables

MayilVahanan — Thu, 27 Sep 2012 18:24:59 GMT

Use

In load statement, create the composite key or create the common name for two tables

Load * , compositekey;

Select * from tablename;

Re: Join tables

Thu, 27 Sep 2012 18:32:59 GMT

Thanks,

It worked....