Convert Column Data into Row Data

Solve in Datastage
Input:
col1, col2, col3
----------------
a, b, c
d, e, f
Output like
Col
---
a
b
c
d
e
f

Questions by sai3689   answers by sai3689

Showing Answers 1 - 4 of 4 Answers

Priyanka

  • Sep 23rd, 2015
 

This can be done using the horizontal pivot logic.
Src ->Pivot stage ->Tgt In the Pivot stage properties, select type as horizontal.
In output define a column COL and map all the Col1,2,3 to this column. Output this COL column to target.

Ram

  • Mar 23rd, 2016
 

Src --> colgen(Dummy) --> Pivot (type=Horizntal & derivaion col=col1,col2,col3) -->copy(drop dummy col) --> trg.

  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