DSXchange

Hi, I need to pass or get from system to create a filename called "filename"_yyyymmdd.txt However, I have problem passing in the paramter from jobs and also triming the "-" or "/" based on the Oconv or Iconv. Any extract(position,xxx) or Trim(xxx) function in DS. I also...

Sorry. I missed some vital information about your environment. I'm using v7.x. I do not know if v6 has a "Remove Duplicates" stage. Someone else will have to help you on this one. Have you tried the derivation options of the Aggregator stage? No yet. But I think tomorrow, I will try the a...

How ? Can you give me more details ?

I currently able to put a new column which is putting MAX(x_field) to
elimate the duplicate but not working, it still returns all the rows.

but when I ran it outside DS, it is working. Does anyone know is there
a different between SQL in DS and others.

Thanks.

Hi, I am new in DS. I need to finish this real fast otherwise I am fired. I extracted the data but I need to sorted it with the most current record, then just send out those records. The header (first record) need to have a hard-coded value 'Header' and a current yyyymm, the trailer (last record) ne...