DataTable filter using "Contains"

Help Studio
, ,
1

Hi,

My source data is an Excel File in where I read the range of the whole sheet and save it in a data table. Sample as below:

image

From the table above, I will filter it by column “Address” and I want to open up a column beside it to write a value that I want to.
Let’s say I filter by (Address “Contains” fine), then the next column it should’ve written “Fine”. Output as below.

image

I will do the filtering by Filter Data Table activity. So whatever under that table I want to write cell in the next column based on my Filter Condition.

How do I go about on this?

Thank you!

2

Hi @remy223

Welcome back to UiPath Forum.

Please try the below method.

image
image1600×900 102 KB

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

Happy Automation

1 Like
3

Hi!,

Thank you for the fast reply. Quick question, in the “Write Cell” for the range is it possible for me to put a column name instead of “D”?

4

No, you can’t able to provide column name instead of range name.

Thanks.

5

Alright noted. I was actually planning to do filter data table because there are multiple if criteria. The “Fine” could be “fine”, “Fine”, “FINE”, and alterations like that. If I use if condition, can I put in multiple conditions?

Thank you.

6

Yes, you can give multiple condition in single if activity. Attached screen shot below for your reference.

image
image1600×900 108 KB

Thanks.

7

If you want to give multiple condition in filter activity. Please find the below screen shot.

image

Thanks.

8

@remy223 - As an alternate …you can just do with one condition

Row(“address”).tostring.toupper.contains(FINE)

Or tolower.contains(fine)

This will first converts your string and check.

9

Hi @remy223

since u need to do filtering and writing the data under type column , u can try this in invoke code with dt1 as In/out Argument

dt1.AsEnumerable().Where(Function(row) row(“address”).ToString.tolower.Contains(“fine”)).ToList().ForEach(Sub(row) row(“Type”)=“Fine”)

then write the datatable dt1 in an excel file

try and let me know if it works for you

Regards,
Nived N
Happy Automation

1 Like
10

Hi @remy223

Did it worked for you ?

11

Hi,

Yes the filter seems to be okay but I am facing issue to open up a column beside to write the value that I want to. Trying to use the write cell method as suggested above currently.

Thank you so much for the assist here!

12

Hi,

I used the “D”+(idx+1).ToString but instead of writing the output in the next column, it just replaces the value in the same Address column. Any idea where I went wrong?

Thank you!

13

Hi @remy223

Instead of “D” you can provide the range where you need to write the cell values.

For example: If you need to write the value in F range, then give like below:

“F”+(idx+1).ToString

Thanks.

14

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