use Row splitter as tranform stage and specified the column name.

Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result "SCH-AS" in onee column and "1010" in
another column.. Can any one tell the answer...

Question Posted / ashutosh g

5 Answers
9104 Views
I also Faced
E-Mail Answers

Answer Posted / ashutosh g

use Row splitter as tranform stage and specified the column
name.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the main differences you have observed between 7.x and 8.x version of datastage?

1025

Can you explain players in datastage?

1144

What are data elements?

1107

Have you have ever worked in unix environment and why it is useful in datastage?

1085

What are the repository tables in datastage?

1259

Explain the situation where you have applied SCD in your project?

1977

Triggers,VIEW,Procedures

1178

What is the importance of the exception activity in datastage?

1018

How can one find bugs in job sequence?

1319

How to RD using transformer?

1367

Have you used Unstructured data?

1269

how to export or import the jobs in .ISX file

1133

What is the sortmerge collector?

1083

How to Remove Duplicate using SQL?

1294

how to abort the job its matain duplicates?

2534