Page 1 of 1

many columns concatenation into one field

Posted: Wed Aug 10, 2005 7:33 am
by Luk
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 !!

Posted: Wed Aug 10, 2005 7:37 am
by chulett
Sorry... better start typing. :wink:

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

Posted: Wed Aug 10, 2005 7:50 am
by lshort
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.

:-)

Posted: Wed Aug 10, 2005 7:58 am
by rsaliah
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.
:wink:

Posted: Wed Aug 10, 2005 8:12 am
by Luk
Thanks Ishort! It is very smart idea :)