# Update the DataTable using Linq

**URL:** <https://forum.uipath.com/t/update-the-datatable-using-linq/408360>\
**Category:** Studio\
**Tags:** activities-panel, question, studio, system, activities\
**Created:** [March 20, 2022, 2:04pm UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360 "2022-03-20T14:04:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shyam\_Pragash](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shyam_pragash/32/279791_2.png) [@Shyam\_Pragash](https://forum.uipath.com/u/Shyam_Pragash)\
**Post date:** [March 20, 2022, 2:04pm UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360/1 "2022-03-20T14:04:11Z")

</div>

Hi..

dt\_table having more than 240 Columns in Datatable..

How to update specific Columns name in the Datatable..

For Example.. (Input)

 ![image](https://global.discourse-cdn.com/uipath/original/4X/9/5/b/95be19ef9047167a45893a055679bd3ddf868f8e.png)

My Data Collection:

 ![image](https://global.discourse-cdn.com/uipath/original/4X/3/8/4/384f5005ea6dc0871c682779c364666e7aec1f31.png)

i have fill the data in input based data collection.

Thanks  
Shyam

---

<div class="post-metadata">

**Author:** ![Sanjit\_Pal](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sanjit_pal/32/193785_2.png) [@Sanjit\_Pal](https://forum.uipath.com/u/Sanjit_Pal)\
**Post date:** [March 20, 2022, 2:27pm UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360/2 "2022-03-20T14:27:59Z")

</div>

@Shyam_Pragash kindly go through it, this might be helpful  
https://www.youtube.com/embed/nsWvD4si9ck?feature=oembed&wmode=opaque&list=PLSM3VHdksDSorYsjIh7odwsUBgil-xE3Y

---

<div class="post-metadata">

**Author:** ![Shyam\_Pragash](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shyam_pragash/32/279791_2.png) [@Shyam\_Pragash](https://forum.uipath.com/u/Shyam_Pragash)\
**Post date:** [March 21, 2022, 3:54am UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360/3 "2022-03-21T03:54:50Z")

</div>

Hi @Sanjit_Pal

i want to overwrite the value in Column based…

Thanks  
Shyam

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [March 21, 2022, 3:58am UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360/4 "2022-03-21T03:58:42Z")

</div>

Hi

Have a view on this thread if you are looking to update all values of a specific column in a datatable  
You can use same expression for multiple columns

> [@Change all values in a column](https://forum.uipath.com/t/change-all-values-in-a-column/293310):
>
> Hi everyone. Is there a way to change the values of an entire column in a datatable, without the need to iterate through the rows of the datable? I have a datatable with many rows that I must replicate equal to the number of days it has in the past month. The only value that changes is the date. Taking the month of October as an example, I currently did a do while that iterates 31 times and in turn inside a for each row to only update the date column. The process works but can take a long tim…

Cheers @Shyam_Pragash

---

<div class="post-metadata">

**Author:** ![Shyam\_Pragash](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shyam_pragash/32/279791_2.png) [@Shyam\_Pragash](https://forum.uipath.com/u/Shyam_Pragash)\
**Post date:** [March 21, 2022, 4:06am UTC](https://forum.uipath.com/t/update-the-datatable-using-linq/408360/5 "2022-03-21T04:06:29Z")

</div>

Hi @Palaniyappan

i have two datatable.

One datatable having more than 200 columns another datatable having 10 columns… i want to overwrite the data using the columns are present in both datatable…

if present overwrite the data…

Thanks  
Shyam