Originally posted by: SystemAdmin

Hi,

I am currently using version 7.1 of DS and I need to create the following from this sample input.

Input

id line# code text
1 1 abc jjjjjjj
1 2 jjhjhj
1 3 jkjkll
1 4 jkjljkl
2 1 abc jkjkjj
2 2 jkjljkll
2 3 kljl;jljh
etc

Output should be

id line# code text
1 1 abc jjjjjjj
1 2 abc jjhjhj
1 3 abc jkjkll
1 4 abc jkjljkl
2 1 abc jkjkjj
2 2 abc jkjljkll
2 3 abc kljl;jljh
etc.
Thanks Angela
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I'm not sure how to do this within TX but it's easy enough in a server job. You use a stage variable in a Transformer stage to remember the value, and use that to load the output column. Search this forum or DSXChange for tips on how to accomplish it.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I have tried using a stage variable to hold the value along with the procedure to get the previous value and using the row comapre function as well. It only seems to work on the second row, but how to get it to continue is my problem.

Example out put I am getting. More details would be greatly appreciated. I am in the process of trying to use two hash files, but it is yeilding the same results.

id line# code text
1 1 abc jjjjjjj
1 2 abc jjhjhj
1 3 jkjkll
1 4 jkjljkl
2 1 abc jkjkjj
2 2 abc jkjljkll
2 3 kljl;jljh
2 4 jkrjkljl

etc.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

not sure this is a DataStage TX post.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I have the answer to this problem. Too difficult to go into the map properly here, so can you log a call with the Ascential helpdesk, and I'll send you the files?

NETechSupport@AscentialSoftware.com

Basically, the trick is to send each row AND the first row down to a functional map:

=F_EachRow(Row:In1,Row[1]:In1)

...and test for the presence of the third item, which if missing, can be taken from the second input card.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

If you do not have a support contract (get one please) then send me a private email, and I'll see what I can do.

paul.brett@ascentialsoftware.com
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange