Compare 2 column values in rows and delete the rows where these column match

[jntrk]

Hey everyone,

I will keep it as simple as possible, I have a datatable DT. It has multiple column and two of its columns are named “old” and “new”

Dt il like following
(Picture is represantation I will read it DT from excel)

(For each row is not an option I have too many lines to go with a for loop)
I want to filter this dt so that only 100-90 column will be remaining I want to remove the lines where old and anew values are equal.

Thank you

[Robinnavinraj_S]

Hi @jntrk

I developed a linq flow as you expected ,
Hope its solve your issue
try out my xaml file and update me whether you got a solution or not
Thanks,
Robin
test21.xaml (8.0 KB)

[jntrk]

I get “the activity is either missing or could not be loaded properly error” could you take a screenshot of the code?

[Robinnavinraj_S]

Hi @jntrk

Try out this syntax

Out_dt = (
From row in yourdatatable_variable
Where cint(row(“old”))<> cint(row(“new”))
Select row
).CopyToDatatable

Thanks
Robin

[jntrk]

thanks alot

[Robinnavinraj_S]

Your welcome