Any way to get the concatenation of input columns done

Mhasan · Post by **Mhasan** » Mon Sep 17, 2007 12:04 am

Hi ,

I have a requiremnt where i have to concatenate all the input columns in to one column.... if number of columns in input is less then no problem ..
If the number of coumns exeeds 100 then it is very tedious job..please suggets if any routine or ..any other way to to this...
ex..
Input columns output colums
A A|B|C|D
B
C
D

ArndW · Post by **ArndW** » Mon Sep 17, 2007 12:07 am

It is a simple matter of using a pipe in Server, but you could effectively do something similar in PX. Write the 100+ columns to sequential file. Then, in another job, read that file but define it with just one column and no column delimiters. You've now concatenated all columns into one.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 1:02 am

Search the forum for "vertical pivot". It's do-able in several ways (though easier in a server job).

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 1:03 am

Search the forum for "vertical pivot". It's do-able in several ways (though easier in a server job).