Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
given below script not connected to 100% accuracy. already saw $syn mark to every connected table please help the remove $syn mark
sagara
CrossTable(DESCRIPTION,BUDGET, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]
(qvd);
CrossTable(DESCRIPTION, BUDGET, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LBUDDATA2015.QVD]
(qvd);
CrossTable(DESCRIPTION, Data, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LDATA2011_2014.QVD]
(qvd);
CrossTable(DESCRIPTION, Data, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LDATA2015.QVD]
(qvd);
LOAD BCOD,
NO,
ACCOUNTANT,
AC_NO,
REGION,
BRA_CAT,
BRA_DBASE,
BRANCH,
DEPT
FROM
[..\..\qlickviwe\Branch.qvd]
(qvd);
Directory;
LOAD PRD_CODE,
CLA_CODE,
PRODUCT,
CLASS,
MO_NM,
IBNR_CLASS
FROM
[..\..\qlickviwe\CLASS_PRD.qvd]
(qvd);
Directory;
LOAD CLA_CODE,
CLASS
FROM
[..\..\qlickviwe\Class.qvd]
(qvd);
Hi,
Use concatenate between each cross table QVD
like
CrossTable(DESCRIPTION,BUDGET, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]
(qvd);
Concatenate
CrossTable(DESCRIPTION, BUDGET, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LBUDDATA2015.QVD]
(qvd);
CrossTable(DESCRIPTION, Data, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LDATA2011_2014.QVD]
(qvd);
CrossTable(DESCRIPTION, Data, 6)
LOAD BCOD,
MONTH,
YEAR,
MONTH2,
CLA_CODE,
MONM,
GROSS_PREMIUM,
SRCC_PREMIUM,
REINSURANCE_FUND,
FOREIGN_COMPANIES,
CEEDED_PREMIUM,
NRP,
UPR_CHARGE,
NEP,
SRCC_TC_COMMISSION,
FOREIGN_CO_COMMISSION,
COMMISSION_INCOME,
NET_REVENUE,
GROSS_CLAIMS,
CLAIMS_RES_FUND,
EXGRATIA_CLIMS_RES_FUND,
CLAIMS_PROCESSING_EXPENSES,
LEGAL_FEES,
RI_RECOVERIES_RI_FUND,
RI_RECOVERIES_SRCC_TC,
RI_RECOVERIES_FOREIGN,
SALVAGE_RECOVERIES,
NET_CLAIMS,
COMMISSION_EXPENSES,
PRODUCTION_BONUS,
DAC_CHARGE,
ACQUISITION_COST,
GROSS_PROFIT,
STAFF_EXPENSES,
ADMIN_EXPENSES,
SELLING_EXPENSES,
FINANCIAL_EXPENSES,
DEPRICIATION_EXPENSES,
MANAGEMENT_EXPENSES,
INV_INCOME_EXT,
INV_INCOME_INT,
OTHER_INCOME_EXT,
OTHER_INCOME_INT,
INV_OTHER_INCOME,
NET_PROFIT
FROM
[..\..\qlickviwe\P&L\P&LDATA2015.QVD]
(qvd);
Regards