Evaluate Data Flow Expressions Inline with Strings in ADF

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

ADF Data Flows allow you to interpret expressions inline strings to easily enable calculations, parameters, and field values as part of your strings. Now, with string interpolation, you can produce super-easy string evaluations using expressions like these samples.

 

Use double-quotes and put any column, parameter, or expression inside curly braces as part of your string:

 

"My favorite movie is {iif(instr(title,', The')>0,"The {split(title,', The')[1]}",title)}"
clipboard_image_0.png
Parameter replacement inside of database query strings:
 
"select * from {$tablename} where orderyear > {$year}"

Inline expressions include full intellisense autocomplete capabilities inside of the curly braces:

 

"Total cost with sales tax is {round(totalcost * 1.08,2)}"

 

clipboard_image_0.png

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.