i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output&nbs

i have input like this

Column 1 ,column 2
3,a
4,b
5.c

i want output
aaa
bbbb
ccccc

Ple help any one?

Question Posted / a

4 Answers
14049 Views
SLK Software, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc..

Answer / satish

Hi

First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable

Str( DSLink2.column_2, DSLink2.Column_1).

Drag and drop the stage variable to required output column,
finally load the data in target.

Is This Answer Correct ?

15 Yes

1 No

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc..

Answer / subbuchamala

Ex:
Str( "a", 3)---->aaa
Str( "b", 4)---->bbbb

Solution:
use below transformer Logic in Output Col Derivation:

Str(DSLink2.col2, DSLink2.Col1)--->Output_Col(Output Column)

Output:

Output_Col
aaa
bbbb
ccccc

Is This Answer Correct ?

3 Yes

0 No

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc..

Answer / naresh

Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable
finally load the data in target.

Is This Answer Correct ?

2 Yes

1 No

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc..

Answer / geetha

use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer