Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have list of timestamps of various stages of contracts . Now my requirement is I need to have the list of all the timestamps between only two stages of any contract.Here :Stage1 is Request Credit Approval and Stage2 is Approved.
Input :
contract_id | input_dt | Status |
18704 | 12-07-2018 12:05 | RM Query |
18704 | 12-07-2018 12:07 | Request Credit Approval |
18704 | 12-07-2018 12:07 | Auto-Approved |
18704 | 12-07-2018 12:07 | PreSanct Doc Verification |
18704 | 12-07-2018 12:56 | RM Query |
18704 | 12-07-2018 12:56 | Correction Required |
18704 | 12-07-2018 13:00 | Approved |
18706 | 24-07-2018 10:54 | RM Query |
18706 | 24-07-2018 10:54 | Correction Required |
18706 | 24-07-2018 13:09 | Manual Approval Required |
18706 | 24-07-2018 13:09 | Qualify |
18706 | 24-07-2018 13:09 | Request Credit Approval |
18706 | 25-07-2018 09:21 | PreSanct Doc Verification |
18706 | 25-07-2018 09:21 | Correction Reply |
18706 | 25-07-2018 10:29 | CO Approval Required |
18706 | 25-07-2018 12:29 | Approved |
18706 | 25-07-2018 13:21 | RM Query |
18706 | 25-07-2018 13:21 | Correction Required |
Output:
contract_id | input_dt | Status |
18704 | 12-07-2018 12:07 | Request Credit Approval |
18704 | 12-07-2018 12:07 | Auto-Approved |
18704 | 12-07-2018 12:07 | PreSanct Doc Verification |
18704 | 12-07-2018 12:56 | RM Query |
18704 | 12-07-2018 12:56 | Correction Required |
18704 | 12-07-2018 13:00 | Approved |
18706 | 24-07-2018 13:09 | Request Credit Approval |
18706 | 25-07-2018 09:21 | PreSanct Doc Verification |
18706 | 25-07-2018 09:21 | Correction Reply |
18706 | 25-07-2018 10:29 | CO Approval Required |
18706 | 25-07-2018 12:29 | Approved |
Thanks in advance,
Ruma
Script / Design?
I need the script.