Match status at script level

[nareshthavidishetty]

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...

[Gysbert_Wassenaar · Accepted solution]

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...

     ;