DSXchange

Hi Ray, Thanks for the reply. The assumption you made is absolutely correct. I came across another scenario where there would be multiple active records and Inactive records. We may need to split inactive records into 3 or ever into 4. Below is the example. Active Records: ------------------ KEY1|Y|...

We have Non active records and Active records overlapping. We need to adjust the date for Non active records so that they will not spill into the active records. In the below example, for the Key1, we have non active record starting at 20140101 and ending at 99991231 and for the same key, we have ac...

Need help with logic to achieve below output:

Below are the source records:

KEY1|N|20140101|99991231
KEY1|Y|20140901|20200101

These needs to be split as below:

KEY1|N|20140101|20140901
KEY1|Y|20140901|20200101
KEY1|N|20200101|99991231

Regards

Hi, Is there any way we can find Max date and Min date if records are continius and other records in a group need to be passed to target if not continious. Source File: Key4|2011-01-01|2011-12-31 Key1|2013-01-01|2013-12-31 Key2|2010-01-01|2012-05-25 Key3|2010-01-01|2010-12-31 Key4|2010-01-01|2010-12...