DSXchange

Hi, My file structure is EMP NO Hours Type 1001 1 A 1001 2 B 1002 4 A 1002 5 B My requirement for every occurrence of the employee number 1 the corresponding hours should be subtracted. There are only two occurences for every employee. O/P should be EMPNO Hours Type 1001 -1 X 1002 -1 X I am trying t...

Hi,
Thanks for the reply.
Could u be more specific on the transformation in the TFM?

thanks,
JJ

Hi, I have to add an extra row in the output file for every employee with the following calculation from the input file. I/P file: A B C D 2011;40S0;12.50,123456 2011;50S0;12.45;123456 2011;40FR;13.56;123456; etc... Now each and every employee with the values (40S0 and 50S0) the values of C column s...

Hi,

I want to calculate the follows:

D= A-B-C .

where A = a+b
B=(e+r+t+p)
C=(t+y+p+u).

I have used aggregator for the B and C values.

kindly let me know.

thanks,
JJ.

will try and get back.

thanks,
JJ

ray.wurlod wrote:This requires a classic fork-join design (though, once you're on version 8.5, you may be able to use looping constructs in the Transformer stage).
One side of the fork (Copy stage) leads to an Aggreg ...

Ok. But how do i implement the same in 7.5 version?

Hi, The following is my file structure: A B C D 2001;40S0;17.50;123456; 2001;500A;02.00;123456; 2001;50S0;16.50;123556; etc... the required output is for every value of B in (40S0 and 500A) the corresponding C column values should be added for the same/different D column value. In the Output i have ...

arvind_ds wrote:Rome was not built in a day

Cool...
:D

Define 4 columns in the column definition of seq file stage with type varchar, put some number in lenght field and nullability no. Set delimeter to semicolon. I tested one job at my end with below data in seq file and it worked fine. 201106;4000;160,50;12345678 200106;4008;6,50;12345679 Are you abl...

arvind_ds wrote:What is the data type for third column.

Change it to varchar, everything written in a sequential file is of type string.

I have tried to use the input file as one string such as Fileinput/varchar/64000 with no nullability. I am using the column as varchar only.

arvind_ds wrote:Your Job Design should be like this.

Seq File --> Transformer --> DataSet

Use semicolon as a Delimeter in Seq File stage properties.

HTH

Hi,
used the same. works for the first two columns but not for the third one.

Hi, The following is my field structure: 201106;4000;160,50;12345678 200106;4008;6,50;12345679 etc.. I have to load these into a Dataset. I have used a transformer for extracting the field info like Input.Fileinput[1,6] like wise and loaded the first two columns in the Dataset. but for the third col...