Hey everyone, I have a datatable which I delete the rows where the rows “first quantity” and “second quantity” column values match. But sometimes the excel is exported faulty and for examle, first quantity value is 72 and second quantity column value is 72000, but actually this a column I want to…

@jntrk [image] ppr: (From d In dtMainData.AsEnumerable Let k1=d("first quantity").ToString Let k2=d("second quantity").ToString Let m = {k1.Length, k2.Length}.Max() Where Not k1.PadRight(m,"0"c).Equals(k2.PadRight(m,"0"c)) Select d).CopyToDataTable Line1 - iterate over datatable, refer to lo…

Delete rows where 2 columns match

Help Activities

ppr (Peter Preuss) March 5, 2021, 6:29pm 12

Padleft padright fills Up a String with a Char to a defined length

What is means tolookup in linq

Topic		Replies	Views
Compare 2 column values in rows and delete the rows where these column match Activities datatable , excel , activities , question , data_manipulation	6	1528	December 28, 2021
Deleting rows from Data Table based on values in multiple columns Studio datatable , excel , uiautomation , studio , question , project_panel , activities_panel	1	810	February 4, 2023
Query to remove datatable Activities excel , activities , question	7	288	June 6, 2023
Delete Rows from a datatable after comparing with another datatable Help	4	4122	January 19, 2020
Delete row Activities excel , activities , question	5	645	April 18, 2022

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

Delete rows where 2 columns match

Related Topics