Gurus,
I have data as below
1 a
1 b
2 c
I wanted to convert it to
1 a b c
tried couple of stages but seems like reverse of pivot is not possible thru them.
Regards,
convert rows to single column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
... and was, in fact, covered yesterday:
<a href="viewtopic.php?t=118685">http://www.dsxc ... =118685</a>
J.
<a href="viewtopic.php?t=118685">http://www.dsxc ... =118685</a>
J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>