Hi Team, I need to change column value based on another value If “yy” column found any negative value should change to column “vv” value if found “NO” i want to change “YES”. Please help me anyone for this. Input: [image] Note: Expected output i marked bold just highlighting purpose. Expected…

@Raja.G Read the data into datatable Then use invoke code by passing dt as io argument Dt.AsEnumerable.Where(function(x) Cdbl(x("yy").ToString.Trim)<0).ToList.ForEach(sub(r) r("vv") = "Yes") After this use write range and write the datatable back Cheers

How to change column value based another column value

Help Activities

ppr (Peter Preuss) October 11, 2024, 9:10am 3

How to Update Data Column Values of a Data Table | Community Blog

later section is elaborating on updating a subset

1 Like

Topic		Replies	Views
Datatable query for update the column values Activities web	5	599	May 23, 2023
Update excel based on value in another column Help excel , activities	9	3755	February 15, 2020
How to change data in one column in data table based on condition of another column Studio studio , question	4	1256	March 26, 2021
How to update cell based on certain condition in datatable using Linq Activities excel , activities , question	5	2535	February 9, 2022
Change column value using LINQ Activities excel , activities , question	16	2130	January 5, 2023

How to change column value based another column value

Related topics