concat string and int

[IAZ]

@burakkaragoz 

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

[IAZ · Accepted solution]

@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 !

[v-sgandrathi]

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!

[IAZ]

I tried the below but of no help.

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

[lbendlin]

try 

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

[IAZ · Accepted solution]

@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 !

[v-sgandrathi · Accepted solution]

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.