How i can Do this
Posted: Fri Nov 03, 2006 2:59 pm
Hi,
I have input like
FV A 0001 6999
FV A 8001 9099
FV A 9101 9299
FV A 9301 9999
GU A 15*
HL A 0001 6999
HL A 8001 9099
HL A 9101 9299
Required OutPut is
Fv A0001-A6999,A8001-A9099,A9101-A9299,A9301-A9999
GU A15*-A
HL A0001-A6999,A8001-A9099,A9101-A9299
In Oracle pluging Stage I did append Then I got required output but that is target level appending if it's reched max length then it's rejecting so, The same appending i need to do same at source leval This means in DataStage pls any one can help me
Thanks in advance
I have input like
FV A 0001 6999
FV A 8001 9099
FV A 9101 9299
FV A 9301 9999
GU A 15*
HL A 0001 6999
HL A 8001 9099
HL A 9101 9299
Required OutPut is
Fv A0001-A6999,A8001-A9099,A9101-A9299,A9301-A9999
GU A15*-A
HL A0001-A6999,A8001-A9099,A9101-A9299
In Oracle pluging Stage I did append Then I got required output but that is target level appending if it's reched max length then it's rejecting so, The same appending i need to do same at source leval This means in DataStage pls any one can help me
Thanks in advance