0

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?

Dimeji Olayinka
  • 71
  • 3
  • 12
  • Hi @Dimeji Olayinka. If my answer is helpful for you, you can accept it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). This can be beneficial to other community members. Thank you. – Joseph Xu Oct 27 '20 at 07:05

1 Answers1

0

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. enter image description here

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

enter image description here

Joseph Xu
  • 5,607
  • 2
  • 5
  • 15