Datastage Scenerio

How i can achieve below logic in datastage
A B C D
B C D
C D
D
it can be number and symbol also
1/2
/2
2

Showing Answers 1 - 3 of 3 Answers

SaravanaKumar

  • Jul 27th, 2019
 

Let assume the input file has one column and the value is "ABCD"
Seq file --> Transformer --> Seq File
In Transformer Create Two stage variable
Len(Inut_Field) -> stageVar
StageVar + 1 -> StageVar1
Under looping give the iteration as @ITERATION <= StageVar
Left(Inut_Field,StageVar1-@ITERATION) -

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions