Forum Discussion

SantoshKumar's avatar
SantoshKumar
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
Solved

Add new Column with some text plus one column data

Hi,

i need to create a new column which should be a combination as below:

Column1 = https://microsoft.visualstudio.com/xxxx/xxx/xxx/1234567

Column1 = "Text"+ABC where ABC is an existing column with value as 1234567 and "text" is supplied value as above mentioned.

 

 

Please help on it.

 

Thanks

Santosh 

Need Help
  • affan's avatar
    affan
    7 years ago

    Hi SantoshKumar

     

    Use the below shown concatenate to create a column also shown below.

    NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])

     

     

     

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

4 Replies

    • affan's avatar
      affan
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Hi SantoshKumar

       

      Use the below shown concatenate to create a column also shown below.

      NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])

       

       

       

       

      If this helped you, please mark this post as an accepted solution and like to give KUDOS .

       

      Regards,

      Affan

    • SantoshKumar's avatar
      SantoshKumar
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi affan

      ABC is available in a column and i am supplying Text (Text does not available in any column)

       

      thanks

      Santosh