circular ref

[sakamsureshbabu]

FYI

BILL MASTER       CALENDER       SALEBUDGET      BRANCHMASTER 
bill date                  bill date             branch                    branch
branch code            month               month                     branch code

how can i eliminate circular ref....

[its_anandrjs]

Hi,

Try to do load script some thing this ways

BRANCHMASTER

branch

branch code

Left Join

SALEBUDGET 

branch

month

BILL MASTER

bill date

branch code

CALENDER

bill date

month

Regards

Anand

[sakamsureshbabu]

i am doing left join 1 syn key was came and graphs are showing 'NO DATA TO DISPLAY'

HOW can i do

[its_anandrjs]

Oh my bad please try this way

Main:

LOAD * Inline

[

branch, branch code

];

Left Join

SALEBUDGET:

LOAD branch, month as SalMonth;

LOAD * Inline [

branch, month

];

BILLMASTER:

LOAD * Inline [

bill date,branch code ];

CALENDER:

LOAD * Inline [

bill date,month ];

And check the combinations of fields from different tables.

Regards

Anand

[sakamsureshbabu]

thank i will try,

please tell me why graphs are showing  'NO DATA TO DISPLAY'

[its_anandrjs]

Hi,

In above example there is no data in the tables it has only fields if you use in the original table with data then it will show no data to display.

Regards

Anand