Load Statement is not working properly

[#1]

The below Load statement is not working proper, it is wrapping most the components in just the EDX option;

LOAD *,

   IF([COMPONENT]='cpms aw application prd' OR [COMPONENT] = 'cpms aw - phoenix licence server software','CPMS',

IF(COMPONENT='tscg','TSCG',

IF([COMPONENT]='electronic document exchange(edx) access improvement tst (itst)' OR

[COMPONENT]='electronic document exchange (edx) safety prd' OR [COMPONENT]<='electronic document exchange (edx) prd' OR

[COMPONENT]='electronic document exchange (edx) scd+1 (primary) integrated test (iuat)' OR [COMPONENT] ='electronic document exchange (edx) qa' OR [COMPONENT]='confidential disclosure agreement (cda) prd','EDX',

IF([COMPONENT]='harp analysis and reporting app prd' OR [COMPONENT]='harp analysis and reporting app prd' OR [COMPONENT]='harp integration application – prd' OR COMPONENT='harp analysis and reporting app val'

OR COMPONENT='harp analysis and reporting app dev' OR [COMPONENT]='biometrics environment linux utilities (bioenv) prd' OR [COMPONENT]='sas on uk1salx00118 prd' OR [COMPONENT]='sas on uk1salx00119 prd','HARP',

IF([COMPONENT]='healthcare information factory (hif) prd gdc' OR [COMPONENT]='hif visualisations prd kop' OR [COMPONENT]='hif visualisations tst kop','HIF',

IF([COMPONENT]='clinical data visibility tool - spotfire server prd'  OR [COMPONENT]='clinical data visibility tool - workflow refresh prd','CDVT',

IF([COMPONENT]<='dmext dataset manager val','DATASET MANAGER',

IF([COMPONENT]='gsk study portal (gsp) prd' OR [COMPONENT]='gsk study portal (gsp) qa' OR [COMPONENT]='gsk study portal (gsp) tst (itst)','GSP',

IF([COMPONENT]='risk based monitoring (rbm) test' OR [COMPONENT]='risk based monitoring (rbm) test','Risk Based Monitoring',

IF([COMPONENT]='enavigator tst' OR [COMPONENT]='enavigator uat','ENAVIGATOR',

IF([COMPONENT]='inet catalist prd kop','INET CATALIST',

IF([COMPONENT]='alsc life sciences cloud - pre prod' OR [COMPONENT]='alsc life sciences cloud - prod' OR [COMPONENT]='alsc life sciences cloud - test' OR [COMPONENT]='alsc cognos reporting - test','Life Science Cloud',

IF([COMPONENT]='decisionview study optimizer stv prd','STUDY OPTIMIZER',

IF([COMPONENT]='dmext spectre prd' OR [COMPONENT]='spectre suite','SPECTRE',

IF([COMPONENT]='decisionview site optimizer prd','SITE OPTIMIZER',

IF([COMPONENT]='transfer of obligations - production','TRANSFER OF OBLIGATION',

IF([COMPONENT]='archive quick check 2.0  prd','ARCHIVE QUICK CHECK','SUPPLIER CONTRACT'))))))))))))))))) AS TICKET_APP;

please someone help me look into, any help would appreciated. stalwar1‌ omar‌

[sunny_talwar]

May be this

LOAD *,

IF([TIER]='GOLD',

    IF(Match([EL_3_],'Yes'),'SLA MET', 'SLA Not Met'),

IF([TIER]='SILVER',

    IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=3,'SLA MET',

    IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=3,'SLA MET',

    IF([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=10,'SLA MET',

    IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=20,'SLA MET','SLA Not Met')))))) as SLA;

[sunny_talwar]

Or this

LOAD *,

IF([TIER]='GOLD',

    IF(Match([EL_3_],'Yes'),'SLA MET'),

IF([TIER]='SILVER',

    IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=3,'SLA MET',

    IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=3,'SLA MET',

    IF([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=10,'SLA MET',

    IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=20,'SLA MET','SLA Not Met')))))) as SLA;

[#4]

It is working but bringing 100% accurate result.

I have attached the App, is when I try loading, its telling me Field: Case_type can not be found, while it is part of a field in my query.

This is the Load Statement below:

LOAD *,

IF([TIER]='GOLD' and [Case_Type]='Incident',

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=1,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=1,'SLA MET',

If([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=10,'SLA MET','SLA Not Met')))),

    IF([TIER]='GOLD' and [Case_Type]='Request',

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=1,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=1,'SLA MET',

If([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=5,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=10,'SLA MET','SLA Not Met')))),

    //if([EL_3_]='Yes','SLA MET','SLA Not Met'),

    //IF([TIER] = 'SILVER',

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=10,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=20,'SLA MET','SLA Not Met')))))) as SLA;

Please help!  omarbensalem‌

[sunny_talwar]

Can you share the error message?

[#6]

Hi Sunny,

    this is the error message :

"

The following error occurred:

Field 'Case_Type' not found

The error occurred here:

?"

omarbensalem‌

[#7]

Have u seen my reply sunny ???