Skip to Content

How to concatenate multiple columns using HANA Flowgraphs

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 25, 2016 at 10:51 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded