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]

Hi,

Its showing correct result when i remove recipt date and takes Raid Revision Date. as calender date.

I just want Raid Revision Date work for this count(Raid_Field1) and for other report works on recipt_date via making receipt date as calender.

Thanks.

[kamalqlik]

Hi Narendra,

Do one thing

Just make a master calendar and link all the date with that master calendar.

Than you will get the correct data as per your requirement.

Meanwhile you are not able to track the correct date.

That is why it is showing the wrong result

Regards

Kamal

[er_mohit]

no   Left Keep function only load those records from which table you have large

suppose i have a table with 1000 records

A:

load 

field1,

field2,

field3

from table;

left keep

B:               // in this table suppose i have 550 records and i want  to load this records only so i using left keep it doesn't join the table it works on input records

load

field1,

field3,

field4

from table; 

[narender123]

Hi.

If i connect master calender with receipt date and Raid Revision Date.then it will make the circular loop because both date table are connect to another intermidiate table that is risk analysis table.

Thanks

[narender123]

So from your point of view where i have to place the left keep function??

As i have shown my current table structure in attachment.

Please tell me.

Thanks.

Narender

[kamalqlik]

Hi Narendra,

When you will make a master calendar.

Suppose

Tempdate as Date

from Master calendar;

Load the other table:

RecieptDate as Date,

RecieptDate as Flag

Load the other table

[Rate Revision Date] as Date

Rate Revision Date as Flag

This will not lead as a result for circular refrence

and ou can use the flag for date identification

Regards

Kamal

[er_mohit]

between both Risk Table

[narender123]

Hi Kamal.

Thanks .

But As you said all three date are same and when you check it via Ctrl+t means datamodeling.It will show circular loop as all 3 names are same.

[narender123]

Ok Mohit .I will check it and let you know.

Thanks.

Narender