What do you mean by 'source 2' ?
Can you provide a pseudo-code of your expected logic.
Search found 3329 matches
- Fri Mar 20, 2009 10:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Combine Data from two different sources using Pivot
- Replies: 11
- Views: 3168
- Fri Mar 20, 2009 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Combine Data from two different sources using Pivot
- Replies: 11
- Views: 3168
Simplest will be an awk statement. Something like
as part of the source.
Code: Select all
awk <params> '
{for (i = 3; i <= NF; i++)
{ printf("%s,%s,%s\n", $1, $2, $i) }
}'- Fri Mar 20, 2009 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Combine Data from two different sources using Pivot
- Replies: 11
- Views: 3168
- Fri Mar 20, 2009 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parrel job warning and not loading data into seq file
- Replies: 3
- Views: 1340
- Fri Mar 20, 2009 4:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to login to Datastage
- Replies: 6
- Views: 1638
- Fri Mar 20, 2009 4:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal Termination of Stage
- Replies: 8
- Views: 10099
- Fri Mar 20, 2009 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to login to Datastage
- Replies: 6
- Views: 1638
- Fri Mar 20, 2009 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to login to Datastage
- Replies: 6
- Views: 1638
- Fri Mar 20, 2009 3:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Instead of "0" want to show empty result
- Replies: 2
- Views: 760
- Fri Mar 20, 2009 3:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Compilation Error for Transformer
- Replies: 8
- Views: 3891
- Fri Mar 20, 2009 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cannot get Exclusive Access to Job to Compile it
- Replies: 8
- Views: 23884
- Fri Mar 20, 2009 3:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Surrogate Key generator stage
- Replies: 3
- Views: 912
- Thu Mar 19, 2009 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to connect Oracle 11g through 7.5 PX Jobs
- Replies: 10
- Views: 3943
- Thu Mar 19, 2009 11:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Buildop Stage - details
- Replies: 7
- Views: 2405
- Thu Mar 19, 2009 10:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StringtoDecimal Issue
- Replies: 7
- Views: 2068