How to concatenate multiple columns using HANA Flowgraphs

[former_member308471]

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

[christoph_gilde · Accepted solution]

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.