I have a column A, B and C. I want to add a new data column called “Full Address”. How can I do this using LINQ? where to add new data column and data contains combination of column A, B and C. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/c/b/b/cbb280aa9c00af60aa48eceb29c7f8c075d8d855.png" data-download-href="/uploads/short-url/t3ZmJ4Go0JS6YlF1p4WCgSYjEdD.png?dl=1" title="The image shows two tables of personal information, one with separated address components under columns A, B, and C, and one with a combined "Full Address" column. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows two tables of personal information, one with separated address components under column…

Hi, We can achieve it using DataColumn.Expression as the following, for example. dt.Columns("Full Address").Expression = "[A] +' '+ [B]+' '+[C]" [image] Sample Sample20241113-4.zip (9.8 KB) Or we can also achieve it using the following LINQ expression instead of the above dt = dt.AsEnumerabl…

Add new data column by combining other columns data using LINQ

Help Studio

system (system) Closed November 16, 2024, 9:38am 7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Concat multiple column data into another column through linq Forum question	3	3695	June 19, 2021
Using linq, to add two different columns and write it in the third column Studio datatable , excel , uiautomation , activities , data_scraping , string , question , data_manipulation	1	2123	January 28, 2021
Add New Column Values To A Datatable using existing Column Values And Change Format Of The Entire Column Values to Number (Using Linq - Both The Case) Studio studio , question , tools	4	3612	May 3, 2021
Add a column data with another column Activities datatable , excel , activities , studio	2	1023	December 21, 2021
How To append Two Cloumns in to another column in Excel using linq Activities excel	3	1446	May 15, 2022

Add new data column by combining other columns data using LINQ

Related topics