DSXchange

I see your problem here, U can use the same logic you mentiuoned in a single transformer and before that you need to initialze the StageVar variable to 0. So that for the very first record you will have 0 + Amount and then subsequently you'll be able to add Amount to StageVar1.

cool... :D mark it as Resolved.

Try using in-line sort with the three columns and mention only the 2 columns as sorking keys in the 'stage' tab on which you want to generage key change column.

Is your data in table1 has maximum 2 records for a id? If the answer to the above question is yes then generate a column say key and assign values to it as shown below table1: Name,id,value,key ---------------- A1,1,100,1 A2,1,200,2 B1,2,400,1 B2,2,300,2 C1,3,100,1 table2: id,value,key ---------- 1...

Is your data in table1 has maximum 2 records for a id?

Is this resolved?

Server Jobs always have this disadvange , it will never point out to a specific error. Try deleting the transformer and introduce a new transformer.

Hi

1. 7.5.1 will be sufficinet to use that server but you cannot use the extra features of 7.5.3 .
2. Yes, But u here also you need to be consious while developing the jobs, You may have compiling Issues.

Internally at the core level.. Both the codes work in the same way So its touch to say which one works better But I Prefer to use a pre-defined function since it is handy.

But if your requirement demands you to use substings then.. thats fine.

It depends on the default format defined at you project level.

Hi

Here the second parameter should always represent your input string format.