Based on Filters Delete Record from Excel

Help Studio
, ,
1

Hello,

I have an excel file and on this file I have to apply filters on columns and then delete record.

So here it go:

I have this table as shown below.

FirstMainTable
FirstMainTable854Ă—405 42.1 KB

I have to apply the below Logic

  1. Select numbers any of those number available 1,2,8,9,11 from First ID Column header, So I selected 1,2,8,9.(as only those were available).

    second
    second820Ă—190 19.1 KB

  2. Now I have to untick the numbers any of those number available 100,200,300 from Second ID Column Header, So I unticked 100,200( as only those were avaiable)

    third
    third991Ă—189 16.9 KB

  3. Now I have to delete the records which comes after doing steps 1 and 2. So as of now I have only 1 row as u can see the above image, so I will delete this.

  4. Now I will clear all the filters and my final table look like this:

    forth
    forth983Ă—469 49.3 KB

So how can I do the same in UiPath Studio any help

2

@iamgeet Have you tried to do this similar Operation using Filter Datatable Activity by Reading the Excel File as a Datatable using Read Range Activity?

1 Like
3

I tried the below:

  1. Read Range
  2. Filter wizard but here I got stuck my output was not as excepted.
4

@iamgeet Can you Show us the Filter conditions that you have used in the Wizard ?

5

yes.
PFA.

filter
filter899Ă—758 62.9 KB

6

I am not sure whether this way is correct or not but I tried and got stuck.

7

@iamgeet So you want to remove rows if “First Id” Column has values 1,2,8,9 and 11 and also if “Second Id” Column does not have the Values 100, 200, 300. Is that right ?

9

Yes u said that is right.

10

@iamgeet Check this Workflow :
I have Initiialised two Arrays based on your Condition, I think the Output is what you need. Try the Workflow for your data and check if it satisfies all the requirements.

FilterBasedOnTwoColumns.zip (8.4 KB)

4 Likes
11

Thanks alot!!!

The workflow you shared is working fine.
Thanks once again :slight_smile:

Regards,
Geeta Maharana

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.