Discussion Board for collaboration on QlikView Scripting.
Hi Dear Qv Community
I have this four tables
I Want obtain this Finally Table
I try several ways but could not achieve the goal, this is the result after concatenante tables
Go to Solution.
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.
Load RowNo() as RowID, ID, Field A resident Tab1;
load RowNo() as RowID, Field B resident Tab2;
load RowNo() as RowID, Field C resident Tab3;
load RowNo() as RowID, Field D resident Tab4;
drop field RowID;
Thanks work finw for me