DSXchange

can u explain me in detail?

which type of unix commands can i use in sequential file filter condition?
i tried sed

but i am getting output as 1 2 3 4

both are also working good.

ntr wrote:if st1 is null then SAL else st1+SAL--------st1

(OR)

if @inrownum=1 then SAL else st1+SAL--------st1


map st1 to sumcolum

make sure the data should be sorted based on SAL

without transformer can we do this scenario?

sv1+sv2->sv2
or
sv1+sv3->sv2 both are working fine..

how to left join those streams? i used datasets

actually my requirement is id,sal,next_row_sal 10,1000,2000 20,2000,3000 30,3000,5000 40,5000,null i got solution for this.but how to get next row value to current row? This is technically impossible, because you can't use a value in a row that DataStage has not read at the time you want to use it. ...

i got solution for this.but how to get next row value to current row?

ray.wurlod wrote:Did you search DSXchange? The technique of using stage variables to remember a value from the previous row has been explained on a number of occasions.
...

k its working.i did one small mistake

can u explain me the logic? i did not get proper output with my logic

TPons wrote:you can implement the logic using stage variables in Transformer stage

---------
Pons

source
id,sal
10,1000
20,2000
30,3000
40,5000

target:
id,sal,cum_sum
10,1000,1000
20,2000,3000
30,3000,6000
40,5000,11000

source
id,sal
10,1000
20,2000
30,3000
40,5000

target
id,sal,pre_row_sal
10,1000,null
20,2000,1000
30,3000,2000
40,5000,3000

i found the solution for this.

seqfile-->sort-->-->transformer-->remove duplicates-->dataset

in sort stage,set create key change column to true.
then u will get the required output

thnx 4 ur reply.
but when i am giving in.accnt in accnts stage variable...
it is showing that 'in.accnts' column is not defined.what is this 'in.'
where to give this else condition