Inline table with Any or Null values

[terezagr]

Hi all,

I have been trying to create an Inline table where in Dec_Code can be any combination, or a specific value from Dec_Code. In Dec_Resp_Code can be a specific value from Dec_Resp_Code, or the field is blank().

APPS:

Load

DEC_RESP_CODE,

DEC_CODE

From APPS.qvd(qvd);

left join (APPS)

LOAD * INLINE [

    DEC_RESP_CODE, DEC_CODE, OFFER_TYPE, OFFER_CATEGORY

    U, Any value , UN OFFER, DECLINE

    Blank , P, TOTALS, PENDING

];

I have tried with no luck:

//first set null interpreter to the string: NULL

SET Nulldisplay =' ';

LOAD * INLINE [

    DEC_RESP_CODE, DEC_CODE, OFFER_TYPE, OFFER_CATEGORY

    U,DEC_CODE , UN OFFER, DECLINE

    , P, TOTALS, PENDING

];

//reset null interpreter

SET Nulldisplay =;

Any suggestions?

[terezagr · Accepted solution]

I have solved this issue. The solution is below:

APPS:

Load

DEC_RESP_CODE as DEC_RESP_CODE_ORIGINAL,

if(IsNull(DEC_RESP_CODE) and DEC_CODE='1P','1P',

       if(IsNull(DEC_RESP_CODE) and DEC_CODE='W','1W',

                 DEC_RESP_CODE)) as DEC_RESP_CODE,

DEC_CODE

from APPS.qvd(qvd);

left join (APPS)

LOAD * INLINE [

    DEC_RESP_CODE, OFFER_TYPE, OFFER_CATEGORY

    U,  UN OFFER, DECLINE

    1P , TOTALS, PENDING

    1W, TOTALS, PENDING    

];