topic Re: concat string and int in Data Engineering

concat string and int

IAZ — Fri, 20 Jun 2025 14:00:19 GMT

Many thanks for you suggestion yesterday. A follow up question:

you suggested the below as a solution yesterday:

@concat(item().source.query, ' ', pipeline().parameters.par1)

But if I set the parameter "par1" as "int" (as the where sql clause needs an int instead of a string) the above expression gives this message "cannot fit number into the function string list. Any help would be greatly appreciated. I tried the below but d

Re: concat string and int

IAZ — Fri, 20 Jun 2025 14:02:27 GMT

I tried the below but of no help.

'@concat(item().source.query, ' ','{@int(pipeline().parameters.sar1)}')

Re: concat string and int

lbendlin — Sat, 21 Jun 2025 14:17:50 GMT

try

@concat(item().source.query, ' ','{@string(pipeline().parameters.sar1)}')

Re: concat string and int

v-sgandrathi — Mon, 23 Jun 2025 04:31:43 GMT

Hi @IAZ,

Thank you @lbendlin for your response.

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

Re: concat string and int

IAZ — Mon, 23 Jun 2025 11:10:36 GMT

@lbendlin

That did not help as the where clause reqd. an int. However I resolved it in the notebook by creating a new column and joining it up with the column that contained the query.

Thanks for your suggestion and appreciate it !

Re: concat string and int

v-sgandrathi — Mon, 23 Jun 2025 12:08:42 GMT

Hi @IAZ,

I'm glad you found a solution and resloved the query. Thank you very much for sharing here.

Kindly mark your reply as the accepted solution so that others in the community can find it quickly.

Thankyou for connecting with Microsoft Community Forum.