Skip to Content
0

How to concatenate multiple columns using HANA Flowgraphs

Dec 16, 2016 at 12:19 PM

426

avatar image

Hi All,

I have a Source table where I have multiple columns.... I wish to concatenate them together and map it to single column in the Target table.

Can anyone help me whether it is possible in flowgraphs and what are the relevant steps?

Regards,

Kiran Shenvi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Christoph Gilde
Dec 25, 2016 at 10:51 PM
0

You can concatenate the columns using standard SQL expression. Use a filter node and put the following expression into the target field:

<source_field1> || <source_field2> ....

In case your source fields are no character field, you might need som conversion functions in between.

Share
10 |10000 characters needed characters left characters exceeded