Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
FYI
BILL MASTER CALENDER SALEBUDGET BRANCHMASTER
bill date bill date branch branch
branch code month month branch code
how can i eliminate circular ref....
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
i am doing left join 1 syn key was came and graphs are showing 'NO DATA TO DISPLAY'
HOW can i do
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
thank i will try,
please tell me why graphs are showing 'NO DATA TO DISPLAY'
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