DSXchange

Hi, I used 4 stage variables KeyCheck,PrevKey,DtCheck and Enddt. PrevKey=KeyCheck in.Key=PrevKey StgEndDt=DtCheck in.EndDt=StgEndDt Through applying constraint in transformer,I got the current record which is rejected.I then left join all Valid Records with this Reject Record and got both the record...

Hi, I have tried this Sort the data on Key and Start Date in Input of transformer if StgVar2=1 and in.StartDate<StgVar3 then FlgReject else FlgValid| StgVar4 in.EndDate | StgVar3 if in.Key=StgVar1 then 1 else 0 | StgVar2 in.Key | StgVar1 Is This Approach correct?

I want to compare only the duplicate records in a file: For eg Key Start Date End Date 1 1/1/2010 1/1/2012 1 1/1/2011 1/1/2012 The data is sorted on key,Start Date in Ascending Order. If EndDate of the First Record is greater than the StartDate of Second Record, then reject both the records and capt...

Hi, I am team member of user who posted this topic. Just to give an update: The function OConv(IConv(date, "D-YMD[4,2,2]"),"DW") is also returning value as 4 in new environment while in old it is returning 3 when we are passing the date as '2014-10-01'. Even for the other dates t...