DSXchange

Ray's suggestion is OK, but you have to beware that the first file in the concatenation ends with a line termination character (in DOS/Windows CrLf). Otherwise you'll loose the first record of the second file and the last record of the first file will look very funny indeed. B. Sorensen, Optico IT ApS

Or if you don't want to use a merge stage, you can read the two sequential files throug two 'empty' transformer stages into a hashfile using Member_Num and Member_Type as keys. Then use the hash-file as input to a sort-stage sorting on 'Member_Num asc, Member_Type asc.' and pass the outlink to your ...

Hi.

As far as I know all lookups are done as '=' (equal to).

Use a constraint to only pass the data where your source file date is within the start/end date criteria.



B. Sorensen,
Optico IT ApS

Hi everybody. It seems that there are many ways to solve this problem. We at Optico has solved it by writing a short routine that emulates the SQL 'IN' functionality. E.G. in a constraint we have the following to check whether a specific user is in the list of users to run for : In(TrimB(Input.cluse...

Hi. We have a number of date routines cooked up if you are interested. For your problem you could call our routine DateAdd like this : DateAdd(Date as timestamp, "MON", 1) And you would get your new date as a reply. Drop us a line if you are interested. The routines are a bit large to incl...

This is a somewhat late reply, but hopefully you'll enjoy it even more then :-) We have built a couple of date-routines that you might like. Amongst others we have DateDiff and DateAdd routines where the developer can choose to use year, month, day, hour etc. for calling. All routines use Date/times...