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
Deleting rows from Data Table based on values in multiple columns Studio datatable , excel , uiautomation , studio , question , project_panel , activities_panel	1	1057	February 4, 2023
Delete row based on value present in col0 and col1 Activities excel , activities , question	19	487	October 27, 2023
Compare 2 column values in rows and delete the rows where these column match Activities datatable , excel , activities , question , data_manipulation	6	1794	December 28, 2021
How to delete the row from datatable2 which has different value from datatable1 Studio studio , question , activities_panel	8	837	January 12, 2023
Delete the extra row from excel based on actual amount Activities excel , activities , question	3	138	June 18, 2024

Delete rows where 2 columns match

Related topics