many columns concatenation into one field

Luk · Post by **Luk** » Wed Aug 10, 2005 7:33 am

Hello, it's me again:)

Maybe you know, how can I concatenate many columns from single stream into one string?
but I don't want to write in every time: DSLink1.colA : DSLink1.colB : ... : DSLink1.colN !!

chulett · Post by **chulett** » Wed Aug 10, 2005 7:37 am

Sorry... better start typing.

Or click on the ellipses (...) and click your way through it.

lshort · Post by **lshort** » Wed Aug 10, 2005 7:50 am

If your source file is Sequential and you want all the columns, you can change the delimeter property for the stage to something that doesnt exist. This will read the row as one long column.
Once you have this long column, if needed, you can replace the actual delimeter with a space, a tab, or whatever.

rsaliah · Post by **rsaliah** » Wed Aug 10, 2005 7:58 am

Just to add to the previous post... Even if your source isn't a Seq file there's nothing stopping you from writing it to a Seq file and using that same method.

Luk · Post by **Luk** » Wed Aug 10, 2005 8:12 am

Thanks Ishort! It is very smart idea