Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that has 2 fields: Account Number and Date Completed. I want to check if an Account Number on a given date exists on the following date. If it exists, I can flag it as NOT complete. If it does not exist, I can flag it as complete. Can anyone help me with the code that I can put in the load script that would allow me to do this? In the example below, the account 12340 on 1/5/15 would be flagged as 'complete' because it doesn't exist in the next existing date, which is 1/8/15.
Account Number | Date Completed |
---|---|
12345 | 1/5/15 |
12340 | 1/5/15 |
12380 | 1/5/15 |
12345 | 1/8/15 |
12380 | 1/8/15 |
12395 | 1/8/15 |
Thanks!
Hi!
Find my attachment
Hope this helps!
KR
Elena
Thank you, worked like a charm!