Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nareshthavidish
Contributor III

Match status at script level

Hi,

Below is the status i want to match at script level and the result will should give as,

Sign Triggered = sent + Declined +Failed +Voided

Envelope STATUS                     

Remarks

Original Error : no document found 

Sign Completed

sent                                

Sign Triggered

Completed                           

Sign Completed

Declined                            

Sign Triggered

Failed                              

Sign Triggered

Signed Envelope                     

Sign Completed

Voided                              

Sign Triggered

Please let me know how to get this.

Thanks...

1 Solution

Accepted Solutions

Re: Match status at script level

I guess you want to map some values to other values. A mapping table and ApplyMap should do that trick:

mapStatus:

MAPPING LOAD [

Envelope STATUS ,Remarks

Original Error : no document found ,Sign Completed

sent ,Sign Triggered

Completed ,Sign Completed

Declined  ,Sign Triggered

Failed ,Sign Triggered

Signed Envelope  ,Sign Completed

Voided  ,Sign Triggered

];

Table:

LOAD

     ...some fields..,

     ApplyMap('mapStatus',[Envelope STATUS]) as Mapped_Status

FROM

   ...source...

     ;

1 Reply

Re: Match status at script level

I guess you want to map some values to other values. A mapping table and ApplyMap should do that trick:

mapStatus:

MAPPING LOAD [

Envelope STATUS ,Remarks

Original Error : no document found ,Sign Completed

sent ,Sign Triggered

Completed ,Sign Completed

Declined  ,Sign Triggered

Failed ,Sign Triggered

Signed Envelope  ,Sign Completed

Voided  ,Sign Triggered

];

Table:

LOAD

     ...some fields..,

     ApplyMap('mapStatus',[Envelope STATUS]) as Mapped_Status

FROM

   ...source...

     ;