Forum Discussion

IAZ's avatar
IAZ
Helper I
1 year ago
Solved

concat string and int

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

data engineering
Data Pipeline
  • IAZ's avatar
    IAZ
    1 year ago

    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's avatar
    v-sgandrathi
    1 year ago

    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.

5 Replies

  • IAZ's avatar
    IAZ
    Helper I
    1 year ago

    I tried the below but of no help.

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

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      try 

       

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

      • IAZ's avatar
        IAZ
        Helper I
        1 year ago

        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's avatar
    v-sgandrathi
    Community Support
    1 year ago

    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!