Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ruma_barman
Creator
Creator

Output on the basis of status of a stage's timestamp

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_idinput_dtStatus
1870412-07-2018 12:05RM Query
1870412-07-2018 12:07Request Credit Approval
1870412-07-2018 12:07Auto-Approved
1870412-07-2018 12:07PreSanct Doc Verification
1870412-07-2018 12:56RM Query
1870412-07-2018 12:56Correction Required
1870412-07-2018 13:00Approved
1870624-07-2018 10:54RM Query
1870624-07-2018 10:54Correction Required
1870624-07-2018 13:09Manual Approval Required
1870624-07-2018 13:09Qualify
1870624-07-2018 13:09Request Credit Approval
1870625-07-2018 09:21PreSanct Doc Verification
1870625-07-2018 09:21Correction Reply
1870625-07-2018 10:29CO Approval Required
1870625-07-2018 12:29Approved
1870625-07-2018 13:21RM Query
1870625-07-2018 13:21Correction Required

 

Output:

contract_idinput_dtStatus
1870412-07-2018 12:07Request Credit Approval
1870412-07-2018 12:07Auto-Approved
1870412-07-2018 12:07PreSanct Doc Verification
1870412-07-2018 12:56RM Query
1870412-07-2018 12:56Correction Required
1870412-07-2018 13:00Approved
1870624-07-2018 13:09Request Credit Approval
1870625-07-2018 09:21PreSanct Doc Verification
1870625-07-2018 09:21Correction Reply
1870625-07-2018 10:29CO Approval Required
1870625-07-2018 12:29Approved

 

Thanks in advance,

Ruma

2 Replies
Anil_Babu_Samineni

Script / Design?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ruma_barman
Creator
Creator
Author

I need the script.