Scenario in Datastage

[SagarMelam]

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

[Thomas.B]

You can do that transformation using a looping transformer :

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...

Then loop while @ITERATION < 6, create 6 fields ( Record,col1,col2,col3,col4 and col5) and use the associated stage variable as derivation.

[ray.wurlod]

Pivot stage (rows to columns).