Compare cell Values

[Shriharsha_H_N]

Hi,

I have a query in DataTable in one datatable Title as same for the 2 Records at that time i need to delete effective status row and keep only pending effective row in the table. kindly advise for the same. Excel screenshot as below.

Input :

Output:

Thanks in advance.

[jack.chan]

Example excel

1. use read range to read excel
   

   

2. use filter data table to keep only status= “Pending Effective” rows
   

   

3. use write range to write the new table
   

   

Result

[NIVED_NAMBIAR (NIVED N)]

Hi @Shriharsha_H_N
In addition to what @jack.chan said

u can use linq query for this too

dt1 = dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals(“Effective”)).CopyToDataTable

Regards,

Nived N

Happy Automation

[Shriharsha_H_N]

Hello @Nived i found this error

[NIVED_NAMBIAR (NIVED N)]

Hi @Shriharsha_H_N

Use that in assign activitiy as it return a datatable with filtered values

[Manish540 (Manish Shettigar)]

@NIVED_NAMBIAR

dt1 = dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals(“Effective”)).CopyToDataTable

You can use below query in condition, @Shriharsha_H_N
dt1 = dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals(“Effective”)).Count > 0.

[vignesh.ks]

Hi @Shriharsha_H_N

Please find the attached xaml file for your reference. Hope this is what you are expecting.

Testing.xaml (15.5 KB)

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation.

[Shriharsha_H_N]

Hello @vignesh.ks

Packages issue kindly suggest the package

[vignesh.ks]

I didn’t used any third-party or additional packages. Below is the screen shot and I attached the zip file for your reference.

FilterDataTable.zip (55.1 KB)

Thanks