Is there where to do line breaks in the expression builder of azure data flow?

Question

I am using the Expression Builder of Derived Column setting of the Azure Data Flow Activity. I am trying to code ac line break. So it looks like:

Value1 Value2

What is the syntax to code this?

Answer 1

You can use '\n' to code ac line break in the DerivedColumn.

In my case, I use concat(Column1,concat('\n',Column2)) epression to concat two columns.

So I get the results, the Column3 looks like:
Value1 Value2