HI,
I need to convert from rows to column inorder to create derive columns
for eq:
ID NAME ATTR_NAME ATTR_VALUE
12521 GENERAL TEMPLATE NAME V
12521 GENERAL RF ZONE TBD
Output should be
ID TEMPLATE NAME RF ZONE
12521 V TBD
Please let me know how to do this using stage variable.. or any other method is there for this..
Thank you
Converting from rows to Columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Converting from rows to Columns
Sandeep Chandrashekar
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Thanks , it's working
Thanks Craig, i have used a logic which will compare current id and previous id and also i have used hash file to produce the output...it's working now..
but my concern is i have 43 derived columns like this...does this slow down the performance.. if so could you give me the tips to counter that..
but my concern is i have 43 derived columns like this...does this slow down the performance.. if so could you give me the tips to counter that..
Sandeep Chandrashekar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: