Appending Multiple column names

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Thu Jan 31, 2008 8:24 am

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=a

c: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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2008 8:35 am

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.

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Thu Jan 31, 2008 9:05 am

Thanks ray for suggestion.
I found one solution for copying column names.
If we create one sequential file job and "include column name as header" we'll get all the columns names.

kcbland · Post by **kcbland** » Thu Jan 31, 2008 9:28 am

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.