Skip to Content

How to concatenate multiple columns from Source and map to single column in Target using 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 16, 2016 at 10:23 PM

    Hi Kiran,

    please have a look at the attached screenshot.

    You can add Mapping expressions inside a Filternode by clicking on an Ouputcolumn and then you will see the mapping expression below.

    You can add Columns to the expression by simply selecting them in the list of elements below, or by dragging and dropping columns from the input table (left table).

    To concatenate two strings you can either use the concat() function or the || operator.

    Best Regards,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded