Add new Column with some text plus one column data

[SantoshKumar]

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 

[affan]

Hi @SantoshKumar

Are you also having the "Text" and ABC both available in separate columns?

[affan · Accepted solution]

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]

Hi @affan

Thank you very much.

Santosh

[SantoshKumar]

Hi @affan

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

thanks

Santosh