selection description

[sagaraperera]

Dear ALL

Kindly advice me the command to select the items highlighted below. and name as 'dep'

Please help me.

DESCRIPTION

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

RI_RECOVERIES_RI_FUND

NET_CLAIMS

COMMISSION_EXPENSES

PRODUCTION_BONUS

DAC_CHARGE

ACQUISITION_COST

GROSS_PROFIT

STAFF_EXPENSES

ADMIN_EXPENSES

SELLING_EXPENSES

DEPRICIATION_EXPENSES

MANAGEMENT_EXPENSES

OTHER_INCOME_EXT

INV_OTHER_INCOME

NET_PROFIT

sagara

[tresesco]

Do you mean the accumulated value for all of them should come under description single 'dep'?

[sagaraperera]

no i want to value separatly

[Anonymous]

In load script try:

Load

DESCRIPTION,

if(match(DESCRIPTION,'GROSS_PREMIUM','CEEDED_PREMIUM','NRP','UPR_CHARGE','NEP','NET_REVENUE','NET_CLAIMS','ACQUISITION_COST','GROSS_PROFIT','MANAGEMENT_EXPENSES','INV_OTHER_INCOME','NET_PROFIT'),DESCRIPTION)  as Dep

From ....;

Not sure how that will display on the community but a simpler version:

IF(Match(DESCRIPTION,'ALL','YOUR','VALUES','PASTED','LIKE','THIS'),DESCRIPTION) as Dep

Hope it helps!