Joining between tables

[narender123]

Hi All,

I have joined my table according to query but the problem starts when i count the "RaidField1" record .

As shown in Attached screen shot.

In screen shot Decleration header is Fact table.I have created the calender from receipt date of decleartion header table.All Table works fine except 1 table "Risk_Rsk_Analysis_Det.Actually i want to count the no. of Raid_Field1 based on date of "Raid_Revision_Date".

What i have to do with my datamodeling???

Thanks in Advance

Narender.

[narender123]

Hello Guys.

Any Idea please??

Thanks

[kaushiknsolanki]

Hi,

     What is the error you are getting.

Regards,

Kaushik Solanki    

[narender123]

Hi,

Thanks for reply.

It showing the wrong count due to taking received date based calender.

When i removed the receipt date means taking  Raid_Revision_Date based calender then it showed the right result.But as i want calender based on receipt date but  for count(raid_field1) it uses  date that means Raid_Revision_Date.

Final result should be: Count(Raid_feild1) based on Raid_Revision_Date.

[kaushiknsolanki]

Hi,

     Its because you have multiple records for each of the RA_CODE in the Risk analysis detail table.

     Kindly post your qvw file.

Regards,

Kaushik Solanki

[narender123]

Sorry Kaushik.

Its heaving very large data .

could you suggest me what i have to do??

Thanks

[kamalqlik]

Hi Just debug it for 100 rows and than paste your qvw.

Regards

Kamal

[narender123]

Hi Kamal.

You are right.But the problem is not like that actually its about project confidentiality.

Thanks for reply.

Narender

[narender123]

Thanks Mohit.

I dont know keep left funtion??

You mean left join.

I didnt use any left join between tables.Tables  connected automatically via same dimention .

Thanks

Narender

[kamalqlik]

Hi Narendra,

your both field are coming from the same table ie Raid_Field1 and Raid Revision Date.

So can you just load that table and validate the datamodel value and please let me know how much differnce are you getting.

Regrads

Kamal