Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ADF Dynamic Expression - concat/if missing period

In what I would have thought was relatively simple code, I can't figure out what the issue is with adding another string to my list of concatenations

Below is the code that I currently have and I get expected output

@concat('start ', if(equals(coalesce(pipeline().parameters.p_source_object.TYPE,''),'x'), 'a', 'b'))

However, I want to add more strings to the concatenation but when I add a comma between the two end brackets like so

@concat('start ', if(equals(coalesce(pipeline().parameters.p_source_object.TYPE,''),'x'), 'a', 'b'), )

I get an "Invalid" error with "Missing period" message. If I put a period before the comma, the error goes away (but obviously invalid syntax)

What is it expecting here?

On a related note, is there a better way to concatenate while also doing some functions that output strings? It's the most unintuitive interface imaginable (Microsoft do seem to pride themselves in the ridiculous!)

Hoping someone can find my sanity for me!

like image 609
RAB Avatar asked Oct 31 '25 08:10

RAB


1 Answers

In the end, I completely reworked it avoiding the layers... however, I have discovered a resolution

@{concat('start ', if(equals(coalesce(pipeline().parameters.p_source_object.TYPE,''),'x'), 'a', 'b'), 'dd')}

While it doesn't stand out as to how... there's a space at the start of the line, this stops it being considered "Dynamic content" but instead uses string interpolation

like image 168
RAB Avatar answered Nov 03 '25 00:11

RAB