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
