cancel
Showing results for 
Search instead for 
Did you mean: 

graphical mapping: concat two field with CRLF

Former Member
0 Kudos

Hi everybody,

I would like to concat two source-fields into one target field. The source-values should be be seperated by CRLF.

How can I achieve this?

Regards Mario

Accepted Solutions (0)

Answers (2)

Answers (2)

vijay_kumar133
Active Participant
0 Kudos

Hi ,

u can achive this by standerd functions..

click on the target field first and then source fields(which need to concat)

and now click functions and select text functions in that second function concat

now map the 2 source fields to concat function and from concat function to target field

double click on concat function and enter the value by which u want to differenciate it..

Reward points if usefull

Regards

Vijay kumar

Former Member
0 Kudos

Hi Vijay,

thank you for your reply. I know about the concat-function.

But unfortunately your reply does not solve my problem.

Thanks, Regards

Mario

Former Member
0 Kudos

Hi,

What does CRLF stands for?

Thanks,

Kiran

Former Member
0 Kudos

CRLF = Carriage Return/Line Feed

Former Member
0 Kudos

Hi,

Please use UDF(User Define Function) for the same. It will be very simple.

Create a UDF with two input fields say a and b and the code is

String result = a"\n"b;

return result;

This will work.

Reward points if find useful

Thanks

Amit