Thanks for replying.
Actaully, it is fixed that there will be no A type records after B type . But the character "B" can come anywhere in data. If "B" comes anywhere within data then use of Index function will fail as it is not actually the start identifier of B type records.
Search found 92 matches
- Wed Oct 06, 2010 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split one row in multiple based on identifier
- Replies: 6
- Views: 3630
- Tue Oct 05, 2010 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split one row in multiple based on identifier
- Replies: 6
- Views: 3630
- Mon Oct 04, 2010 2:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split one row in multiple based on identifier
- Replies: 6
- Views: 3630
Split one row in multiple based on identifier
Hi, We have a requirement where we are getting a fixed width file of length 60. The source system is sending the data in below format A-----A-----B---------B---------B---------B---------@@@@@@@@ A-----A-----A-----A-----B---------B---------@@@@@@@@@@@@@@@@ A-----A-----A-----A-----A-----A-----A-----A-...
- Fri Jun 26, 2009 12:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert row data into column based on key
- Replies: 1
- Views: 1310
Convert row data into column based on key
Hi ,
I have a reuirement to convert the row data into column based on key.
The data will be like
1|A
1|B
1|C
2|X
3|Y
3|Z
Output should be like :
1|A,B,C
2|X
3|Y,Z
Pls Help!!!
I have a reuirement to convert the row data into column based on key.
The data will be like
1|A
1|B
1|C
2|X
3|Y
3|Z
Output should be like :
1|A,B,C
2|X
3|Y,Z
Pls Help!!!
- Wed Apr 08, 2009 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change One Column data to One row (Pivot)
- Replies: 1
- Views: 1619
Change One Column data to One row (Pivot)
Hi All, I have one requirement to convert the data coming in multiple rows to one row. I will try to explain the scenario with an example. Data is like Col A ==== 1000 2000 4570 2345 The requirement is to get the data like Col A ==== 1000,2000,4570,2345 Source is Oracle and Target is File. Thanks fo...
- Sat Sep 20, 2008 4:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SAP Plug-in Information
- Replies: 2
- Views: 1809
- Sat Sep 20, 2008 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warnings in the Lookup stage
- Replies: 14
- Views: 7784
- Sat Sep 20, 2008 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Rejects
- Replies: 6
- Views: 5658
- Sat Sep 20, 2008 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Rejects
- Replies: 6
- Views: 5658
- Fri Sep 19, 2008 11:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Funny characters in Sequential file columns of a paralell jo
- Replies: 4
- Views: 2889
- Fri Sep 19, 2008 10:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date conversion
- Replies: 2
- Views: 1690
- Fri Sep 19, 2008 10:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem converting String to Decimal
- Replies: 1
- Views: 1488
- Fri Sep 19, 2008 10:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to export jobs
- Replies: 2
- Views: 2441
- Fri Sep 19, 2008 10:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get matched records between two columns
- Replies: 15
- Views: 6693
- Fri Sep 19, 2008 10:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Append system date and time to a file name in Seq File Stag
- Replies: 10
- Views: 14044