Search found 12 matches
- Thu Aug 25, 2011 2:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Subtraction of values using Stage variables in a transformer
- Replies: 4
- Views: 3136
Subtraction of values using Stage variables in a transformer
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...
- Tue Aug 23, 2011 9:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Addition of an row
- Replies: 4
- Views: 3093
Re: Addition of an row
Hi,
Thanks for the reply.
Could u be more specific on the transformation in the TFM?
thanks,
JJ
Thanks for the reply.
Could u be more specific on the transformation in the TFM?
thanks,
JJ
- Tue Aug 23, 2011 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Addition of an row
- Replies: 4
- Views: 3093
Addition of an row
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...
- Tue Aug 23, 2011 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation
- Replies: 1
- Views: 1931
Calculation
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.
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.
- Mon Aug 22, 2011 4:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field calculation
- Replies: 4
- Views: 3243
- Mon Aug 22, 2011 2:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field calculation
- Replies: 4
- Views: 3243
- Mon Aug 22, 2011 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field calculation
- Replies: 4
- Views: 3243
Variable field calculation
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 ...
- Fri Aug 19, 2011 6:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field manipulation
- Replies: 9
- Views: 12551
- Fri Aug 19, 2011 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field manipulation
- Replies: 9
- Views: 12551
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...
- Fri Aug 19, 2011 5:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field manipulation
- Replies: 9
- Views: 12551
- Fri Aug 19, 2011 5:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field manipulation
- Replies: 9
- Views: 12551
- Fri Aug 19, 2011 5:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable field manipulation
- Replies: 9
- Views: 12551
Variable field manipulation
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...