How to compare 2 columns, if the 2 columns have same data then entire row has to removed

[Manisree_Parasa]

I have the input file as below

And I need the output as below

Thanks…

[Srini84 (Srinivas Kadamati)]

@Manisree_Parasa

Welcome to forums

You can use Linq function for this

Check below for your reference

Hope this may help you

Thanks

[Manisree_Parasa]

Thankyou @Srini84

Is this possible without using linq. If so could tell me

[Srini84 (Srinivas Kadamati)]

@Manisree_Parasa

Without linq you can use For Each row activity
Check as below, dt will be your actual data
Use another datatable variable dt1 and assign as dt.clone

Hope this may help you

Thanks

[Manisree_Parasa]

Could you please attach the whole file.
Thanks

[Srini84 (Srinivas Kadamati)]

@Manisree_Parasa

Check below for your reference

DeleteMatchedRows.zip (961.7 KB)

If this helps you
Mark as solution and close this thread

Thanks

[Srini84 (Srinivas Kadamati)]

@Manisree_Parasa

You welcome

Happy Automation

Thanks

[Manisree_Parasa]

But the third column was not printed. In the build data table you didn’t add the third column

[Srini84 (Srinivas Kadamati)]

@Manisree_Parasa

For demo purpose I add only first two columns

You can add other columns you have

Thanks