1 Reply Latest reply: Jul 14, 2016 8:37 AM by Gysbert Wassenaar RSS

    Match status at script level

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

        • Re: Match status at script level
          Gysbert Wassenaar

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

               ;