Skip to Content
0

How to concatenate multiple columns from Source and map to single column in Target using Flowgraphs?

Dec 16, 2016 at 06:11 AM

41

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
Timo Wagner
Dec 16, 2016 at 10:23 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded