%3CLINGO-SUB%20id%3D%22lingo-sub-1053589%22%20slang%3D%22en-US%22%3EEvaluate%20Data%20Flow%20Expressions%20Inline%20with%20Strings%20in%20ADF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053589%22%20slang%3D%22en-US%22%3E%3CP%3EADF%20Data%20Flows%20allow%20you%20to%20interpret%20expressions%20inline%20strings%20to%20easily%20enable%20calculations%2C%20parameters%2C%20and%20field%20values%20as%20part%20of%20your%20strings.%20Now%2C%20with%20string%20interpolation%2C%20you%20can%20produce%20super-easy%20string%20evaluations%20using%20expressions%20like%20these%20samples.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20double-quotes%20and%20put%20any%20column%2C%20parameter%2C%20or%20expression%20inside%20curly%20braces%20as%20part%20of%20your%20string%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%0A%3CPRE%3E%3CSPAN%3E%22My%20favorite%20movie%20is%20%7B%3C%2FSPAN%3E%3CSPAN%3Eiif%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3Einstr%3C%2FSPAN%3E%3CSPAN%3E(title%2C%3C%2FSPAN%3E%3CSPAN%3E'%2C%20The'%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CSPAN%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%2C%22The%20%7B%3C%2FSPAN%3E%3CSPAN%3Esplit%3C%2FSPAN%3E%3CSPAN%3E(title%2C%3C%2FSPAN%3E%3CSPAN%3E'%2C%20The'%3C%2FSPAN%3E%3CSPAN%3E)%5B%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3E%5D%7D%22%2Ctitle)%7D%22%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160468iB1AB7F2EE01C4770%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3EParameter%20replacement%20inside%20of%20database%20query%20strings%3A%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CPRE%3E%3CSPAN%3E%22select%20%3C%2FSPAN%3E%3CSPAN%3E*%3C%2FSPAN%3E%3CSPAN%3E%20from%20%7B%3C%2FSPAN%3E%3CSPAN%3E%24%3C%2FSPAN%3E%3CSPAN%3Etablename%7D%20where%20orderyear%20%3C%2FSPAN%3E%3CSPAN%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%3E%20%7B%3C%2FSPAN%3E%3CSPAN%3E%24%3C%2FSPAN%3E%3CSPAN%3Eyear%3C%2FSPAN%3E%3CSPAN%3E%7D%22%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3EInline%20expressions%20include%20full%20intellisense%20autocomplete%20capabilities%20inside%20of%20the%20curly%20braces%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%0A%3CPRE%3E%3CSPAN%3E%22Total%20cost%20with%20sales%20tax%20is%20%7B%3C%2FSPAN%3E%3CSPAN%3Eround%3C%2FSPAN%3E%3CSPAN%3E(totalcost%20%3C%2FSPAN%3E%3CSPAN%3E*%3C%2FSPAN%3E%20%3CSPAN%3E1.08%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3E2%3C%2FSPAN%3E%3CSPAN%3E)%7D%22%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160486i98C3BAFA937312DF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1053589%22%20slang%3D%22en-US%22%3E%3CP%3EADF%20Data%20Flows%20allow%20you%20to%20interpret%20expressions%20inline%20strings%20to%20easily%20enable%20calculations%2C%20parameters%2C%20and%20field%20values%20as%20part%20of%20your%20strings.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1053589%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBig%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1110196%22%20slang%3D%22en-US%22%3ERe%3A%20Evaluate%20Data%20Flow%20Expressions%20Inline%20with%20Strings%20in%20ADF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110196%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20this%20only%20work%20if%20you%20click%20on%20the%20add%20dynamic%20content%20link%20first%20or%20can%20you%20just%20type%20it%20into%20a%20field%20without%20using%20the%20expression%20builder%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20can%20you%20show%20an%20example%20of%20using%20dynamic%20database%20strings%20in%20the%20data%20flow%20-%20not%20sure%20how%20to%20implement%20it%20just%20from%20the%20explanation%20above%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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
1 Comment
Occasional Visitor

Does this only work if you click on the add dynamic content link first or can you just type it into a field without using the expression builder?

 

Also can you show an example of using dynamic database strings in the data flow - not sure how to implement it just from the explanation above?