ETL and Data Integration tools - Modern ETL software for everyone

Hello

I would like to join customer address fields using comma + CR+LF
so far I was able to produce using joiner
adddress1,adddress2,adddress3,adddress4

but I need something like this:
adddress1,
adddress2,
adddress3,
adddress4

I am thinking about using calculation but wandering if there any more elegant solutions?

Marc

There is a much simpler solution for your data transformation.

use Ensure suffix for first three address lines + joiner

See the picture attached

Peter

Yes, you are right it is much easier.

Mark