concatenate 30 fields

just4u_sharath · Post by **just4u_sharath** » Wed Dec 12, 2007 7:19 pm

I have a question. i would like to concatenate30 fields which i will get from input. To concatenate i dont like to use a transformer. Is there any other stage in Parallel extender which aids me in concatenating. Only requirement is to concatenate and i transformer should not be used

ray.wurlod · Post by **ray.wurlod** » Wed Dec 12, 2007 7:43 pm

No, short of using an External Filter stage (which will run sequentially and slowly).

vmcburney · Post by **vmcburney** » Wed Dec 12, 2007 9:03 pm

Have a look at the Column Export stage, it lets you concatenate a number of columns of different datatypes into a single large varchar or binary data type. You can choose to pass some columns straight through the stage to ensure you only merge the 30 columns. You can set the delimiter to "none" for concatenation. With "Column Method" of "Explicit" you choose the columns by adding the "Column to Export" property 30 times and choosing columns from a drop down list. With "Column Method" set to "Schema File" you can maintain the list of columns to be merged in an external text schema file giving you almost no code or configuration to maintain in the stage.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 13, 2007 5:50 pm

Nice one. Please ignore my earlier absolute "no".