source data :
ColumnA
-----------
111
AAA
222
BBB
333
CCC
Output:
Col1 Col2
111 AAA
222 BBB
333 CCC
I assume we can achieve this with the design
Src-->Txfm (constraint alpha and num functions and generate dummy column with sequence numbers)----> numbers& alphabets------merge--->col1 col2
I am stuck in the sequence generating part because one row goes to 1 o/p and another row to other o/p hence there wouldn't be same dummy key values to merge..Please let me know on this
separate values of a single column to 2 columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
separate values of a single column to 2 columns
N.Srinivas
India.
India.