DSXchange

Set the LIB environment variable to the location of the library directory for the SDK. For example, for Microsoft Visual Studio .NET 2008 Express Edition C++, a typical location is C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib. Set the INCLUDE environment variable to the location of the include ...

I fully agree with you Criag.

Have you tried Concatenating the unique seq numeric value to varchar field?

Are you using Extended Microseconds for timestamp fields?

Since Name will relate to specific Emp_ID, I will suggest as follows:

Partition and Sort on Emp_ID
Sort only on Seq_Num

typo correction:

Define four stage variables in the exact order.
svNewKey = input.Emp_ID
svKeyChange = svNewKey <> svLastKey or svLastKey = ""
svLastKey = input.Emp_ID
svDesc = if svKeyChange then input.Desc else svDesc : input.Desc
[/list]

Ok.. Here is the logic to do key break Define four stage variables in the exact order. svNewKey input.Emp_ID svKeyChange svNewKey <> svLastKey or svLastKey = "" svLastKey input.Emp_ID svDesc if svKeyChange then input.Desc else svCounter : input.Desc Make sure to Partition and Sort on Emp_I...

Are you sorting the input field MKT_SGMNT_CD in Merge stage?

Use KeyBreak detection logic using stage variables to concatenate DESC field and use lastrowingroup function to get the last row.
Please let me know if you need more info

What you can do is create one more stage variable and handle only the dates from your input record for the another column. It will be as follows: Input rec: KEY DESC DATE 123 AAA 1/05/09 123 BBB 5/24/11 123 CCC 2/22/12 452 AA 5/2/04 452 BBB 3/6/06 631 AAAA 5/6/10 Output: Key DESC ANOTHER COLUMN 123 ...

Change | to " on " and change , to \n or CHAR(10) for New Line

Pons..

sv_Opening_Bal ---> if @INROWNUM=1 Then 0 Else sv_Prev_Clsoing_Bal
sv_Prev_Clsoing_Bal ---> closingbal

will not work in Parallel env unless you run your transformer in seq. mode.

What have you tried so far?

Do this: Create a rownum column as int so your input will look like this: rownum, date , closingbal 1, 12thmay,2000 2, 13thmay,3000 3, 14thmay,4000 4, 17thmay,6000 5, 20thmay,8000 Now.. using Copy Stage, split the rows in Two stream as follows: 1. rownum and closingbal will go to Transformer. 2. row...

yes.. you can use basic transformer in Parallel Job. By the way to get to Server Job.. click File > New and Click on Jobs folder.. Here you will find Server Job option