Join Table

[upaliwije]

Hi Friends

I have two data table as shown  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

[john_obrien]

Friend,

Maybe these are best kept as 2 different tables in the data model, because they have different dimensions.  Table 2 has the claim_no field and the values apply to a single claim.  Table 1 seems to apply to all the claims for a policy in a single year. 

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.

I hope that helps a bit.