@@@@calling All Datastage Developers@@@@

[dalapathi]

[quote name='arey ooo samba' timestamp='1333644485' post='1301602697']

avnu baa
..transformer loo ee funtion use chesi strip cheyaloo adram avvatledu
[/quote]
field function use cheyyi........

Field(InputColumn,' ', 1)

aah space ki mundhu vunnadhi vastadhi...........try chesi chuudu.........emi vachindoo cheppu

[dalapathi]

[quote name='dalapathi' timestamp='1333644897' post='1301602714']
field function use cheyyi........

Field(InputColumn,' ', 1)

aah space ki mundhu vunnadhi vastadhi...........try chesi chuudu.........emi vachindoo cheppu
[/quote]
tom taruvaata space vundi & vuntey..........ee field function work avvaali.........try chesi result emochindhoo cheppu

[mettastar]

'&' adi delimiter and field function use chesaka trim chesko just in case emanna spaces vasthayemo

[qwerty1204]

[quote name='dalapathi' timestamp='1333644959' post='1301602721']
tom taruvaata space vundi & vuntey..........ee field function work avvaali.........try chesi result emochindhoo cheppu
[/quote]

I sould have elaborate my case in the previous reply

the input data can be like this

TOM NICK & ADAM
SAM F RICK & ANDY RAM

in the above data

my output should be

TOM NICK
SAM F RICK

field function will be gud..if there is only a single word before "&" but ikkada ala ledu baa data

[mettastar]

[quote name='arey ooo samba' timestamp='1333476334' post='1301594111']

nenu ila cheyali ani anukuntunna baa


for example

1st input row: column not null kadu..so it has to split into two rows in output ..so I use the loop iteration variable and generate the output as 1 for the first row of output and 2 for the second row of the output.

2nd input row: column null anukoo..then output row should be numbered as 3

3rd input row: column again null anukoo then the output row shoulb be numbered as 4

4th input row: column not null anukoo..then we have two output rows numbered 5 and 6 (logic is same as for 1st input row case)

so overall ga enti ante..if input column is not null then it should go through the loop ..if not don't go to the loop condition..but how to keep track of the incrementing number anedhi naa question
[/quote]
baaa transformer nunchi 3output links theesko and aa moodu funnel chesko
oka link emo 'NULLS' ki define chesko, inka rendu 'NOT NULL' ki
and sequence number emo Stagevariables lo generate chesko depending on whether the column is null or not null
and one more thing neku previous seq number thelvali ante Second Stage Variable First Variable lo call chesthe always previous value of that Second Stage Variable first daniki pass avuthundi

[mettastar]

[quote name='arey ooo samba' timestamp='1333645601' post='1301602751']

I sould have elaborate my case in the previous reply

the input data can be like this

TOM NICK & ADAM
SAM F RICK & ANDY RAM

in the above data

my output should be

TOM NICK
SAM F RICK

field function will be gud..if there is only a single word before "&" but ikkada ala ledu baa data
[/quote]
Field Syntax - Field(Column,'Delimiter',Position)
In your case below shud work for u
Field(InputColumn,'&',1)
'&' adi delimiter

[dalapathi]

[quote name='mettastar' timestamp='1333645778' post='1301602760']
Field Syntax - Field(Column,'Delimiter',Position)
In your case below shud work for u
Field(InputColumn,'&',1)
'&' adi delimiter
[/quote]
yeah.........idhi try chesi chuudu.......

[qwerty1204]

[quote name='mettastar' timestamp='1333645621' post='1301602752']
baaa transformer nunchi 3output links theesko and aa moodu funnel chesko
oka link emo 'NULLS' ki define chesko, inka rendu 'NOT NULL' ki
and sequence number emo Stagevariables lo generate chesko depending on whether the column is null or not null
and one more thing neku previous seq number thelvali ante Second Stage Variable First Variable lo call chesthe always previous value of that Second Stage Variable first daniki pass avuthundi
[/quote]

Thanx baa...I implemented in the same way yesterday and got my intended result


[quote name='mettastar' timestamp='1333645778' post='1301602760']
Field Syntax - Field(Column,'Delimiter',Position)
In your case below shud work for u
Field(InputColumn,'&',1)
'&' adi delimiter
[/quote]



nuvvu DS ee na baa

[dalapathi]

[quote name='arey ooo samba' timestamp='1333646248' post='1301602783']
Thanx baa...I implemented in the same way yesterday and got my intended result






nuvvu DS ee na baa
[/quote]
DS aey.......

[pandemkodi]

or else

you can you this

trim(left(column,index(column,'&')-1))

[pandemkodi]

oh cinma ipoinda

[qwerty1204]

[quote name='pandemkodi' timestamp='1333646401' post='1301602797']
or else

you can you this

trim(left(column,index(column,'&')-1))
[/quote]

derivation lo error chupisthundi baa...

[pandemkodi]

i used this one in my job ba
its working fine
Trim(left(Lnk_Input,index(Lnk_Input, char(9),1)))

[qwerty1204]

[quote name='dalapathi' timestamp='1333646376' post='1301602793']
DS aey.......
[/quote]

[qwerty1204]

[quote name='pandemkodi' timestamp='1333647421' post='1301602860']
i used this one in my job ba
its working fine
Trim(left(Lnk_Input,index(Lnk_Input,[b] char(9)[/b],1)))
[/quote]


enti baa adhi..we have to give..substring value aa akkada