topic Re: Join Table in QlikView https://community.qlik.com/t5/QlikView/Join-Table/m-p/66959#M11061 <HTML><HEAD></HEAD><BODY><P>Friend,</P><P>Maybe these are best kept as 2 different tables in the data model, because they have different dimensions.&nbsp; Table 2 has the claim_no field and the values apply to a single claim.&nbsp; Table 1 seems to apply to all the claims for a policy in a single year.&nbsp; </P><P>If you need to calculate a new field with data from both table (ex. ratio of claims to premium) then you can aggregate table 2 by grouping on policy_no and year. </P><P></P><P>I hope that helps a bit.</P></BODY></HTML> Wed, 07 Mar 2018 18:28:24 GMT john_obrien 2018-03-07T18:28:24Z Join Table https://community.qlik.com/t5/QlikView/Join-Table/m-p/66958#M11060 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have two data table as shown&nbsp; below and I want to format output table and that too is shoen below. I useed joun technique then the data get dupicated. Kindly help to do this since concatanate command I am not using as there so many different fields in my actual data table </P><P></P><P><IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195589_Screenshot_3.png" style="height: 272px; width: 620px;" /></P></BODY></HTML> Wed, 07 Mar 2018 17:55:46 GMT https://community.qlik.com/t5/QlikView/Join-Table/m-p/66958#M11060 upaliwije 2018-03-07T17:55:46Z Re: Join Table https://community.qlik.com/t5/QlikView/Join-Table/m-p/66959#M11061 <HTML><HEAD></HEAD><BODY><P>Friend,</P><P>Maybe these are best kept as 2 different tables in the data model, because they have different dimensions.&nbsp; Table 2 has the claim_no field and the values apply to a single claim.&nbsp; Table 1 seems to apply to all the claims for a policy in a single year.&nbsp; </P><P>If you need to calculate a new field with data from both table (ex. ratio of claims to premium) then you can aggregate table 2 by grouping on policy_no and year. </P><P></P><P>I hope that helps a bit.</P></BODY></HTML> Wed, 07 Mar 2018 18:28:24 GMT https://community.qlik.com/t5/QlikView/Join-Table/m-p/66959#M11061 john_obrien 2018-03-07T18:28:24Z