I'm using DS server 7.1 version on Unix environment.
I want to append multiple coulmn names into a single.
Say for e.g:
Input Col Output Col
a e
b
c
d
where the value of e=ac:d
Since in Input have nearly 2000 columns it's a daunting task to append the column names.
Can anybody suggest me a simple way of doing this?
Thanks in advance
Appending Multiple column names
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Daunting, tedious, but not difficult. Suggestion, build a few at a time in stage variables: there is an upper limit on the length of an expression.
And beware of nulls.
And beware of nulls.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
I absolutely thought you were doing an ETL exercise just like Ray. You were looking to get the list of columns in metadata for some reason. You've got yourself a reasonable solution.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle