HELP

[sagaraperera]

I WANT TO REMOVE $SYN MARK SOWN BELOW PICTURE PLEASE HELP

SAGARA

Directory;

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);

[Gysbert_Wassenaar]

You already posted that question here: $SYN . Please stop cluttering this site with unnecessary discussions.

[giakoum]

Not very clear what you need. Do you get a synthetic key? A sample app would help

[Gabriel]

Hi,

What you want to achieve is not clear, kindly explain.

Also, I think you can possibly resolve the syn key by concatenate you tables. The first 3 loads can be concatenate and so is the bottom table. But to get accurate answer please explain more what you want to