Line break in Dataflow expression builder

Question

We use an table in source of a dataflow, we can't find a good way to make a query wit parameter : If we use a classic code editor we can't use parameters on the query, if we use an expression bulider with CONCAT function we can use line break on the query so the code was difficult to read. We try with concat for each line but it's send \n to the database

Answer 1

Hello Isabelle Cardoso, Thanks for the question and using MS Q&A platform. Have you read this article: https://stackoverflow.com/collectives/azure/articles/75215092/how-to-parametrize-query-in-lookup-activity
I think you can try out a similar expression.

Himanshu
Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.