topic Joining tables problem in QlikView

Joining tables problem

Wed, 10 Oct 2012 14:57:42 GMT

Hi Dear Qv Community

I have this four tables

Tab1

Tab2

Tab3

Tab4

I Want obtain this Finally Table

I try several ways but could not achieve the goal, this is the result after concatenante tables

Wed, 10 Oct 2012 18:04:42 GMT

Your data model is assuming that ID is a primary key but it is not. That's why any type of join with this data source will not work.

Your primary key seems to be ID and field A. but that link is not in all tables.

However it does look like the load order dictates the join. so you could do this.

JoinedTable:

Load RowNo() as RowID, ID, Field A resident Tab1;

join

load RowNo() as RowID, Field B resident Tab2;

join

load RowNo() as RowID, Field C resident Tab3;

join

load RowNo() as RowID, Field D resident Tab4;

drop field RowID;

Wed, 10 Oct 2012 18:43:21 GMT

Thanks work finw for me