Hi ,
I have below scenario.
we receive data from a file as below
Record
col1
col2
col3
col4
col5
Record
col1
col2
col3
col4
col5
The same pattern continues ..and it should be loaded into table as below
Record col1 col2 col3 col4 col5.
Please advice me
Scenario in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
Scenario in Datastage
Sagar
You can do that transformation using a looping transformer :
Create 6 stages variables as below
Then loop while @ITERATION < 6, create 6 fields ( Record,col1,col2,col3,col4 and col5) and use the associated stage variable as derivation.
Create 6 stages variables as below
Code: Select all
SvRecord : If @ITERATION = 0 Then Ln_Input.InputCol Else SvRecord
SvCol1 : If @ITERATION = 1 Then Ln_Input.InputCol Else SvCol1
Etc...
BI Consultant
DSXConsult
DSXConsult
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: