Concatenating columns

ady · Post by **ady** » Thu Dec 07, 2006 9:05 am

I need to concatenate the first 10 columns of the source data.

say the columns are 1,2,3,4,5,6,7,8,9,10 then i'm using 1:2:3:4:5:6:7:8:9:10 , is there a simpler way to do it so that i dont have to enter all the column names ?

chulett · Post by **chulett** » Thu Dec 07, 2006 9:09 am

Nope.

ady · Post by **ady** » Thu Dec 07, 2006 9:11 am

I have to CONC 25 columns so thats bad news for me, Anyway..

.... thanks Chulett

ray.wurlod · Post by **ray.wurlod** » Thu Dec 07, 2006 9:20 am

Why? You only construct the expression once, if you take care to get it right first time.

ady · Post by **ady** » Thu Dec 07, 2006 9:26 am

I need to do it for about 50 tables with different column names. So i need to keep changing the column names for every job.

I am concatenating the columns and again pulling out substrings from that so if i happen miss a column its gonna be a mess.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 07, 2006 9:28 am

Then don't (miss out a column). Take care. Take breaks, so you can continue to concentrate (and for your eye health).

ady · Post by **ady** » Thu Dec 07, 2006 1:41 pm

I will ..