Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Considerations-
1) covernote Number and Issue Date are coming in-line with Each Other & In Mentioned Sequence.
2) Data Arrives in Ascending Order of Issue_Date
Pseudo-Code
1) Split Issue_Date Column. Capture Month & Date into two Difference Array Variables/Dataset (as Preferred)
date_array1[]= issue_date.split(1)
month_array2[]=issue_date.split(2)
2) Store CovenantNo into another array
covenant_no_array3[]= loop(Covenant Number)
3) Apply Bubble Sort (Quick Sort Can also be done for Faster Results, but Bubble Sort will be easy to identify out of Order Value.)-
a. First on month_array2[] (use as outer loop)
b. Second on date_array1[] (use as inner loop)
4) When out of Order Value found, print that value as Current Value. Pre-Value is index-1 of Current Value. Post Value is index+1 of current value. Covenant number is index of current value,
used in covenant_no array
i.e.
current_value= date_array1
pre_value= date_array1[i-1]
post_value= date_array1[i+1]
covenant_no=covenant_no_array3
how to do it in script and expression
can u help me in dis
HI sagar
you can try this in sorting tab
Sort by expression (Ascending):
=Date#(Day&Month&Year, 'DDMMMYYYY')
ty sir for giving ur time
i m having certain covernote_number and pol_issue_date.
as in this table
covernote number | pol_issue_date |
2302168904 | 18-Nov-2014 |
2302168905 | 18-Nov-2014 |
2302168908 | 18-Nov-2014 |
2302168910 | 19-Nov-2014 |
2302168915 | 20-Nov-2014 |
2302168931 | 20-Nov-2014 |
2302168934 | 11-Nov-2014 |
2302168940 | 21-Nov-2014 |
2302168945 | 22-Nov-2014 |
2302168946 | 22-Nov-2014 |
sir this date table is in proper ascending order .
bt my problem comes when date i.e. pol_issue_date is not in proper order .
will gv u example :
COVERNOTE_NUMBER | POL_ISSUE_DATE |
2302168701 | 16-Oct-2014 |
2302168715 | 29-Nov-2014 |
2302168717 | 28-Nov-2014 |
2302168718 | 26-Nov-2014 |
2302168720 | 28-Nov-2014 |
2302168721 | 19-Nov-2014 |
sir look at this :
first covernote_number is 2302168701 and its pol_issue date is 16\oct\2014
(in this both covernote_number and pol_issue_date is correct in sequences )
second covernote_number is 2302168715 and its pol_issue date is 29\nov\2014
(in this covernote_number and pol_issue_date is correct as its upper date is of oct month and this date is nov so it correct )
third covernote_number is 2302168707 and its pol_issue date is 28\nov\2014
(in this covernote_number is right and pol_issue_date is not in order date is 28-nov-2014 from above date is bigger that is 29\nov\2014 month )
as
as all the rest are in not order
so i want the output in dis way
all the pol_issue date which are not in order it should through this output as below
COVERNOTE_NUMBER | POL_ISSUE_DATE |
29-Nov-2014 | |
2302168717 | 28-Nov-2014 |
26-Nov-2014 |