Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
PROFIT:
CrossTable(DESCRIPTION, ACTUAL, 4)
LOAD BAL_BRANCH_CODE AS BCOD,
YEAR,
MONTH,
CLA_CODE,
GROSS_PREMIUM,
CEDED_PREMIUM,
NET_PROFIT
FROM
Actual_TB.Qvd
(qvd)
WHERE BAL_BRANCH_CODE='1M00'
;
Concatenate(PROFIT)
CrossTable(DESCRIPTION, BUDGET, 4)
LOAD BGT_BRANCH_CODE AS BCOD,
Budget_TB.Qvd
WHERE BGT_BRANCH_CODE='1M00';
When I run the above script I get the following error message
llegal combination of prefixes
Pls help me to solve this problem.
My requirement is to load two cross table and concatenate the same. If you find a better solution pls advice
me
Hi Upali,
I got your point. Let try this script:
tmpPROFIT: CrossTable(DESCRIPTION, ACTUAL, 4) LOAD BAL_BRANCH_CODE AS BCOD, YEAR, MONTH, CLA_CODE, GROSS_PREMIUM, CEDED_PREMIUM, NET_PROFIT FROM Actual_TB.Qvd (qvd) WHERE BAL_BRANCH_CODE='1M00'; tmpBUDGET: CrossTable(DESCRIPTION, BUDGET, 4) LOAD BGT_BRANCH_CODE AS BCOD, YEAR, MONTH, CLA_CODE, GROSS_PREMIUM, CEDED_PREMIUM, NET_PROFIT FROM Budget_TB.Qvd (qvd) WHERE BGT_BRANCH_CODE='1M00'; [FinalTable]: LOAD * Resident [tmpPROFIT]; Concatenate([FinalTable]) LOAD * Resident [tmpBUDGET]; DROP Tables [tmpPROFIT],[tmpBUDGET];
tmpPROFIT:
FROM Actual_TB.Qvd (qvd) WHERE BAL_BRANCH_CODE='1M00';
tmpBUDGET:
FROM Budget_TB.Qvd (qvd) WHERE BGT_BRANCH_CODE='1M00';
[FinalTable]:
LOAD * Resident [tmpPROFIT];
Concatenate([FinalTable])
LOAD * Resident [tmpBUDGET];
DROP Tables [tmpPROFIT],[tmpBUDGET];
Regards,
Sokkorn
Tks Max
Then I get the following Syn Table Message
Actual_TB << Actual_TB 20 lines fetched
ACTUAL << Actual_TB 540 lines fetched
Budget_TB << Budget_TB 13 lines fetched
BUDGET << Budget_TB 351 lines fetched
ACTUAL << ACTUAL 1,080 lines fetched
BUDGET << BUDGET 702 lines fetched
DROP TABLES ACTUAL,BUDGET
$Syn 1 = BCOD+YEAR+MONTH+CLA_CODE+DESCRIPTION
Hi
Still I have this Syn Table Problem with Following Message
What about this way
tmpPROFIT: CrossTable(DESCRIPTION, ACTUAL, 4) LOAD BAL_BRANCH_CODE AS BCOD, YEAR, MONTH, CLA_CODE, GROSS_PREMIUM, CEDED_PREMIUM, NET_PROFIT FROM Actual_TB.Qvd (qvd) WHERE BAL_BRANCH_CODE='1M00'; tmpBUDGET: CrossTable(DESCRIPTION, BUDGET, 4) LOAD BGT_BRANCH_CODE AS BCOD, YEAR, MONTH, CLA_CODE, GROSS_PREMIUM, CEDED_PREMIUM, NET_PROFIT FROM Budget_TB.Qvd (qvd) WHERE BGT_BRANCH_CODE='1M00'; [FinalTable]: NoConcatenate LOAD * Resident [tmpPROFIT]; DROP Table [tmpPROFIT]; Concatenate([FinalTable]) LOAD * Resident [tmpBUDGET]; DROP Table [tmpBUDGET];
NoConcatenate
DROP Table [tmpPROFIT];
DROP Table [tmpBUDGET];
Thanks All
